Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lherbert501
Helper V
Helper V

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)  

lherbert501_4-1677084204746.png

b) 

 

lherbert501_5-1677084220718.png

 

 

c) 

lherbert501_7-1677084417905.png

 

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

 

 

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

 

 

View solution in original post

3 REPLIES 3
lherbert501
Helper V
Helper V

This is amazing @amitchandak  Thankyou!!

amitchandak
Super User
Super User

@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

 

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.