Hi All
Is it possible to have one measure's column within another one?
For example, I have:
In this case light blue column should go within the gold one. The new measure’s total should remain the same with $17.6 and the $9.27 with a different color.
The measures are:
Total Target =
Var Target =
CALCULATE(
[LATAM Target],
ALL('Type with total'))
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target,
[LATAM Target]
)And the other one is:
OU Target =
Var Target =
CALCULATE(
[Company Target],
ALL('Type with total'))
Return
SWITCH(
SELECTEDVALUE('Type with total'[Type]),
"Total",Target,
[Company Target]
)Is that possible?
Thanks.
@o59393 it is possible, you have to create some grouping table and then use stack bar chart using that grouping.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
