Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to Solution.
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
)
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
)
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:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!