cancel
Showing results for
Did you mean:

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

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:

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

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:

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

Thanks.

1 ACCEPTED SOLUTION
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
)
2 REPLIES 2
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
)
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:

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors