Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |