Forum Discussion
Stacked Column Chart Formatting
Thank you for this clear post and for providing data
Done, here the result
my file is here
https://drive.google.com/drive/folders/14HuWjOKld9A5x-oHacplyMRa6J5rNyjd?usp=sharing
What I did:
1 - created a column "Fake label" to have only empty spaces and so hide type 1 etc ut keep the different result and column for each
2 - created a DAX measure to avoid showing the value for type-12
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Thank you for this clear post and for providing data
Done, here the result
my file is here
https://drive.google.com/drive/folders/14HuWjOKld9A5x-oHacplyMRa6J5rNyjd?usp=sharing
What I did:
1 - created a column "Fake label" to have only empty spaces and so hide type 1 etc ut keep the different result and column for each
2 - created a DAX measure to avoid showing the value for type-12
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
FBergamaschi Thanks so much for your time and help. Really appreciate it!
However, I was hoping to show a single value for type-12 (which is just the sum of type-1 and type-2), instead of leaving it blank like in the screenshot I attached with question.
I tried tweaking the 'level' measure you shared, but, I couldn’t get it to work. Not even sure if this is doable.
If you have any ideas or suggestions, please let me know!
I got the solution using total labels instead of data label.
Accepting your answer as got the idea from you for the fake label.
Thank you.
More than welcome
I think data label is not working properly.
If I use "Data label" with the measure you gave and turned off "Total labels" then I am not seeing the total of the type-12 (below screenshot)If I turned on the "Total labels" then I am getting the below output
My expected output would be (I need one data label for every types).
Any idea how can I do this?
