Forum Discussion
Data Layout Query
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 , 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-fc4095ae9afd
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-299a0ae3725fCalculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
3 Replies
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-fc4095ae9afd
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-299a0ae3725fCalculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
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
This is amazing amitchandak Thankyou!!
