Forum Discussion
Grouping Measures
saumitra , Please explore field parameters or calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi,
I think this similar thread is discussing the solution you are looking for:
https://community.powerbi.com/t5/Desktop/Slicer-to-hide-or-unhide-measures-in-a-line-chart/m-p/1147352#M520805
Hi,
I couldn't understand how it will show all 3 measures together if nothing is selected? Kindly please explain. Thanks!
saumitra , Please explore field parameters or calculation groups
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi amitchandak , I saw the video that you have shared. Great video. I was able to get the slicer measure as I required.
However, in the video you have also grouped Net and Net Target together under "Actuals" and "Target". But in my case, I have Actuals, Targets and Projections. How do you suggest I should add all three into the DAX that you have created?
I tried using the following DAX but it is throwing an error, which I couldn't understand. Kindly please explain.
