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.
Good Day - I recently (with help) was able to get my visual as I needed! All the stores are ranked on Sales to Budget and then separated into 4 Quartiles based on Rank.
Here is my issue: I want to add in Region Code that DOES NOT change the rank and Quartile but only displays that specific region in the visual. Sort of just hides the other regions so that regional manager can see quickly where all his stores fit within the company.
This is the visual when all regions are selected. When I go to look at HTX region - it litterally filters the dataset and the ranks and quartiles mess up.
In EXcel it is easy....
Essentially - I don't want the filter to filter on the results but just what one sees. Any help??? 🙂
Solved! Go to Solution.
A really nice power user: @Parvinder Chana solved this for me!! I needed to use "ALL" and not "SELECTALL" in my ranking measure.
Thx!
A really nice power user: @Parvinder Chana solved this for me!! I needed to use "ALL" and not "SELECTALL" in my ranking measure.
Thx!
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 |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
7 | |
1 | |
1 | |
1 | |
1 |