Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
84 | |
79 | |
63 | |
51 | |
30 |
User | Count |
---|---|
116 | |
114 | |
70 | |
66 | |
39 |