Forum Discussion
Stacked Column Chart Formatting
- 1 year ago
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!