Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I had created field parameter in which there is a dropdown for each field in each field there are multiple categories say Product color had 7 similarly product color had multiple I need to restrict these on visual only top 4 so that when I select any drop down I should get only top 4 in the stack bar chart .and one should be selected as default
Solved! Go to Solution.
@mwasekaar
Could you explain this part "one should be selected as default "
I have attached a file with the solution. please check if this works for you.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Many thanks for the quick response
Hi @mwasekaar
You will need to create a rank measure that switches between different columns depending on the field parameter order selected and then use this measure as a visual filter. The default rank column in the screenshot below is Country as it's order is 0 and the alternative result in SELECTEDVALUE is 0.
Proud to be a Super User!
@mwasekaar
Could you explain this part "one should be selected as default "
I have attached a file with the solution. please check if this works for you.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |