Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a table called 'Main Data' which shows data similar to the below:
Module No Owner Developed Reviewed Signed Off
1 A Yes Yes No
2 B No No No
3 C Yes Yes No
4 D Yes No No
5 A No No No
6 B Yes Yes Yes
7 B Yes Yes No
etc.
I have created a visual which shows the progress of each owner in all 3 columns together (counting all of the 'Yes' responses vs. the Total responses). I have done this by creating 2 measures:
Measure 1 (Current Progress) =
Measure 2 (Total) = (COUNTROWS('Main Data')*3)
Now I want a slicer on the page which can filter the data for only specific columns i.e. only developed or reviewed or signed off. But I have no idea how to implement this in PowerBI. The two ways I have tried so far have failed:
1) Using Field Parameters - this doesn't work as Field Parameters cannot replace the relevant data within my measures (parameters in measures is not yet supported in PowerBI)
2) Unpivoting columns - this solution creates chaos with my other metrics and visuals in the dashboard
Could anyone help me please?
Thank you!
Solved! Go to Solution.
Unpivoting is the right thing to do in most cases. See if you can overcome the chaos by adjusting the rest of your report.
Unpivoting is the right thing to do in most cases. See if you can overcome the chaos by adjusting the rest of your report.
Hi, yes you are correct, I managed to overcome this issue through unpivoting the selected columns within a duplicate version of the same dataset (so my other visuals were not affected). Thank you 🙂
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
72 | |
67 | |
51 | |
38 | |
26 |
User | Count |
---|---|
89 | |
52 | |
45 | |
39 | |
38 |