Data Layout Query

[lherbert501]

Hi there,

I've gone with the approach to my data of having it vertically as an example below in a) so that I can filter through that value to display in the dashboard slicer , instead of b), so that the slicers can run a lot smoother through my report like in c) instead of too many bookmarks.

a)  

b) 

c) 

My question is, after displaying my data in the format of a), is there a way that I can then display it as b) in a drillthrough table, even though its in the same column? 

I hope that makes sense

Thanks

[lherbert501]

This is amazing @amitchandak  Thankyou!!

[amitchandak · Accepted solution]

@lherbert501 , You can create measures and use field parameters or calculation groups

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[lherbert501]

Hi @amitchandak 

If I have two views of a stacked chart (profit and sales)  . As there is two measures in each, is it possible to do this in a way that allows me to use the profit and sales button above to select whether I view the profit view or the sales view?

I almost need to be able to group both measures for the one option in the field parameter