Forum Discussion
Custom sorting a slicer does not work
Hello all, For some strange reason, I suddenly cannot sort a slicer using a custom list. I create the list, double click on it with the slicer selected- nothing. I delete the slicer, create the l...
gs_aujla ,
So, you have no empty string cells. That is strange if you have EXACTLY the same Pivot table with and without data model with different results here. Perhaps relationships are different, blank row label could appear if no matching rows in related (child) table. Something with aggregation.
Unfortunately I'm not so deep in DAX to say something more concrete without playing with file.
SergeiBaklanHi .. I am creating a new dashboard with a new Pivot Table and it's own Data Model to use DAX. But my new Excel worksheet keeps on calling the old Data Model for a different Excel workbook. Can't I have multiple Data Models for different worksheets in my domain?