Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
We need to display our most popular brands (for example brand A and brand B) for different territory. The end user will choose a store within our custom appliction. Base on the store location, we want to show the rank for brand A or brand B, but not both. Right now we display two score cards - one for each brand ranking at store location, not ideal solution. Is there any way we can achieve to show just one brand ranking?
Thanks,
Wenchi Wang
Hi @Anonymous
It is very hard to provide an accurate solution without looking at sample data.please follow the How to Get Your Question Answered Quickly to post your simplified assumed data and expected output.It would be better if you can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |