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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.