Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a dim table with columns and values like this:
I am trying to get a visualization table that looks like this:
When the user selects a project with the slicer, the table should change to the project that has been selected.
Is there a standard way to handle this in Power BI? I know I could unpivot the dim table, but this would obviously screw up the data relationships.
Solved! Go to Solution.
here is a workaround for you
create a new table
column 1 sort by sort column
then create a measure
Proud to be a Super User!
here is a workaround for you
create a new table
column 1 sort by sort column
then create a measure
Proud to be a Super User!
That worked, thanks a lot!
you are welcome
Proud to be a Super User!
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |