Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I want to create a filter so users can select 'Profit', 'Costs' and/or 'Revenue'. This three aspects has to be shown in one graph. However, for every selection, there are measures created for every year (from 2017 up to and including 2021).
I know it's possible to create a slicer which returns one measure, but I am not sure if and how it's possible to return five measure when you select 'Profit' for example.
The table with two columns are added and a screenshot of my measure, the filer 'Selection' and the graph with the results how it supposed to be (the measure doesn't work, so this graph isn't shown).
The measure is as follows:
Solved! Go to Solution.
Hi @Anonymous ,
So you have 5 measures for each selection? Can you add selection column to the measures as filter parameter so that you could create only 5 measures totally. And you may consider to add the year column to legend field so that you don't need to create measure for each year. Please correct me if I misunderstand your meaning.
Best Regards,
Jay
Hi @Anonymous ,
So you have 5 measures for each selection? Can you add selection column to the measures as filter parameter so that you could create only 5 measures totally. And you may consider to add the year column to legend field so that you don't need to create measure for each year. Please correct me if I misunderstand your meaning.
Best Regards,
Jay
Hi @v-jayw-msft ,
Thank you! Adding the year column to the legend field was a big step forwards, and I didn't think of that.
I still wanted to have all three aspects - profit, costs and revenue - in one visual. I used the trick as explained in this YouTube video:
So, now I was able to show all years in one graph and easily going from one graph to another (profit, costs, revenue) without taking a up much space
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |