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.
Hello everyone! I am stuck with a Dashboard I need to create any help will be greatly appreciated.
I have some ids (e.g. A, B, C,…), and some groups (e.g. gr1, gr2, gr3,…). Each ids belong to certain groups. I need a Dashboard which can filter the ids using the groups. In other words, I want to be able to select certain groups, in order to reduce the list of ids to only the one being in EACH of the selected group.
For now the best I was able to do is the following:
i.e. using one filter(i.e. slicer) per group, with one table of ids. The table will show only the ids with the value selected in the filter.
I would like to have only one filter (and not one per group), as I have a lot of groups.
When I reverse the idea of how the data/filter is organized and I can have it this way:
, but note that in that case I have all the ids that are in at least one of the selected group, and not in EACH selected group.
Thank you very much!
Best
Solved! Go to Solution.
Hi! Thank you for both interesting answer!
What solved my probelem was to add three measure as explained in this tutorial:
https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5
Note that hierarchical slicer is not enough as a solution.
Thank you for your help!
Hi! Thank you for both interesting answer!
What solved my probelem was to add three measure as explained in this tutorial:
https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5
Note that hierarchical slicer is not enough as a solution.
Thank you for your help!
@Anonymous,
According to the requirement, perhaps hierarchySlicer can meet your requirements.
Reference: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Does my In Common Quick Measure help here?
https://community.powerbi.com/t5/Quick-Measures-Gallery/In-Common/m-p/382956
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |