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

Frequent Visitor

## Scale y axis based on legend selection

I have the following bar chart setup in PowerBI. Sum of cut is generally but not always much smaller than sum of fill. I'd like to be able to display them together but I'd also like the y axis to scale appropriately when I select just sum of cut in the legend. Is there a way to achieve this? Currently when I select sum of cut I get the below screenshot, sum of fill is greyed out but still present. Doesn't neccesarily have to be through the legend, I would be happy to have a slicer I am just not sure how to setup a slicer to pick variables to display.

1 ACCEPTED SOLUTION
Super User

Hi @ICTJZT
You can use field parameters to achieve the goal ( with a slicer not from legend) if the values are 2 different measures.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI
if it is split by category that you put on legend, just create a simple slicer with these categories as a field.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
1 REPLY 1
Super User

Hi @ICTJZT
You can use field parameters to achieve the goal ( with a slicer not from legend) if the values are 2 different measures.

Please refer to the linked tutorial:

https://www.youtube.com/watch?v=V6WchPDZibI
if it is split by category that you put on legend, just create a simple slicer with these categories as a field.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

## Helpful resources

Announcements

#### 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.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors