I wan't to do a simple task of having a 100% Stacked Column Chart showing values of my dataset normaly instead of %.
Is that possible? I can't find the solution.
Here's an example of what I wan't using Excel:
This chart shows Victory total in blue and Defeat total in red by each law suitcases request.
I have to admit that I do not understand what you mean by
"... 100% Stacked Column Chart showing values of my dataset normaly instead of % ..."
Why can't you just use a "normal" stacked column chart?
Because the normal stacked column doenst show the difference in each column, it compares each columns.
My objective is not to compare each column, but to compare the total victory and defeat on each request and see which one I have a major victory or defeat but, instead of %, showing the exact value.
I can show the problem I'm having on the picture below:
Thank you for answering!
I'm open for ideas.
Just tried the Mekko visual as @andrecalais already suggested, but wasn't able to get the "absolute" value, besides the tooltip. but the tooltip also shows the absolute value for the normal "%stacked column chart"
Could be some line of R code using the ggplot2 package, but then you couldn't use the visual for cross filtering other visuals.
But Tom, would other visuals (like the Slicer for example) change the R coded visual? But not the other way around.
I will also post as a idea for Microsoft to enable other options for values visualization on 100% Stacked Column Chart.
Hey @andrecalais, yes all other viusals (also slicer) would have impact on the R script visual, as the filter down the data that will be passed to the R script visual.
If you provide some sample data (upload a pbix to onedrive or dropbox and share the link I will give it a "quick" shot 🙂
Unfortunaly I can't provide the data I'm using, I'll try to take sometime and make one with different names and stuff so I can share it.
I'll also try to workaround with R.
I'll leave the post open for people to bring new solutions.
Please, vote the idea for more data label options on 100% Stacked Column Chart
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps