Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |