Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! Learn more
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:
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 65 | |
| 45 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 115 | |
| 114 | |
| 38 | |
| 36 | |
| 26 |