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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Sander1401
Helper II
Helper II

1 visual with 2 field parameters

Hi all,

I need some help.
I want to built 1 visual (stacked bar chart) with 2 field parameters.
The visual needs the possibillity to switch between absolute figures vs percentual, but also the possibillity to change the legend of the stacked bar.
The absolute figures formula is just 1 field, but the percentual formula is depending on the dimension of the legend, this is my formula when I don't have the possibillity to change the legend:

 
Percentual =
    DIVIDE(
        SUM('Fact'[Count]),
        CALCULATE(
            SUM('Fact'[Count]),
            REMOVEFILTERS('Fact'[Legend-dim1])
        ))
 
So I want 1 visual with 2 slicers:
1. absolute vs percentual
2. legend-dimension 1 vs legend-dimension 2
 
In this PBIX I've made a simple dashboard with 2 visuals, can anyone help me if it's possible to combine these?
Dashboard 2 field parameters 
 
I am stuck!
2 REPLIES 2
amitchandak
Super User
Super User

@Sander1401 , Check the attached file after signature

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Unfortunately this isn't working properly, this is just the problem I also had.
Just look at the Y-axis of the visuals when selected percentual and legend-dim2:

Sander1401_0-1679587955580.png

The formula of the percentual measure is 'focused' on legend-dim1, so when legend-dim2 is selected, it doesn't work.
But I do not know how to fix it.

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors