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,
currently i am using two meausres in stacked y axis and one measure in line chart. and x axis is the time line.
every month, two measures A & B are stacked one above the other. and other measure C is line axis which plotted along the time line X axis.
we have a requirement to slice/filter the measure B for some categories within that. some how i can filter the measure B for any one category, but alwasy the measure A & measure C would remain C. the slicing and filter should be only for measure B.
But i need the measure B to show the groupings/slicing in it self.
Thanks,
Suresh K
Solved! Go to Solution.
In this scenario, you can fix the category filter within Measure A and Measure C formula. For example, your Measure A is calculating total on Column A, and you have a Category selection in a slicer, you can write your Measure A like:
Measure A = CALCULATE(SUM(Table[Column A]),ALL(Table[Category]))
Regards,
In this scenario, you can fix the category filter within Measure A and Measure C formula. For example, your Measure A is calculating total on Column A, and you have a Category selection in a slicer, you can write your Measure A like:
Measure A = CALCULATE(SUM(Table[Column A]),ALL(Table[Category]))
Regards,
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |