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

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

Reply
o59393
Post Prodigy
Post Prodigy

Modify measure in column

Hi all

 

I need to remove the column value from X-Axis "Type" and keep it just for the Total.

 

Below the current state:

 

o59393_0-1693851140789.png

 

Instead I would like to have it like this (light blue column just on totals):

 

o59393_1-1693851185654.png

 

The measure is the following:

 

 

 

OU Target = 
Var Target =
CALCULATE(
    [OU Savings Target],
        ALL('Type with total'))
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target,
        [OU Savings Target]
)

 

Where Type with total is:

o59393_2-1693851320534.png

 

 

How can I keep the light blue bar just in total x-axis?

 

Thanks.

1 ACCEPTED SOLUTION
o59393
Post Prodigy
Post Prodigy

I was able to solve it:

 

Just removed the [OU Savings Target] from the dax code. Final one is:

 

OU Target = 
Var Target =
CALCULATE(
    [OU Savings Target],
        ALL('Type with total'))
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target
)

View solution in original post

2 REPLIES 2
o59393
Post Prodigy
Post Prodigy

I was able to solve it:

 

Just removed the [OU Savings Target] from the dax code. Final one is:

 

OU Target = 
Var Target =
CALCULATE(
    [OU Savings Target],
        ALL('Type with total'))
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target
)
o59393
Post Prodigy
Post Prodigy

I modified the dax

OU Target = 
Var Target =
CALCULATE(
    [OU Savings Target],
        ALL('Type with total'),'Type with total'[Type]="Total")
    Return
    SWITCH(
        SELECTEDVALUE('Type with total'[Type]),
        "Total",Target,
        [OU Savings Target]
)

 

And the light blue bar dissapeared from the total and remained in the rest, which is the opposite of the solution I am looking for:

 

o59393_0-1693852161577.png

 

Helpful resources

Announcements
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 Kudoed Authors