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.
Hi Community,
I am struggling to find a solution for this for many days, and wanted to seek help in resolving this.
I have a table that has list of entities and their description and the values for the corresponding year. The request is to find the the entities that have common description across the years (years are selected from slicer). Below is the sample table:
when the years are selected from slicer (for example: 2020 and 2021) I should be seeing graph like the below table:
When the years 2021 and 2022 are selected then I should see the below as a table/graph:
When years (2020, 2021 and 2022) are selectd then the below should apppear as table /graph.
Also, the year slicer can have any number of years and expectation is to display the entities that have description for all the selected years in bar chart.
Also, if there are more than 3 description items that are matching all the selected years then we should display only top 3 values for that entities that have description for all the selected years.
Please can anyone help me here...
Thanks,
AnthonyJoseph
try like:
Hi @FreemanZ
THanks, but it is not showing the expected values. The output table is showing True if any one of the value is in the slicers but in our case, it should be true only when all the years selected or in the entity/description.
Please can you help me in this.
Did I understand you right, you select a year / some years and want to know only the entities which a represent in every year? Did are other tables involved ? Dimension table for the entities ?
Proud to be a Super User!
Yes your understanding is right.... I need to display the entites which matches all the years that are all selected ( not any one of the selected years).... Appreciate your help on this
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |