Forum Discussion
How I mix two graphs
- ElliotP9 years agoPost Prodigy
If you need to use a clustered column to visualise your data it might not visualise to demonstrate the meaning you want. In the sense that for example, if on the same clustered bar column you want to show "All", "Male" and "Female"; the % value for "All" won't show 100% but rather whichever proportion of the new total sum under consideration.
Using a vertical bar chart and the legend feature could be a good idea. Or creating your own percentage measures (could even use the quick calc in powerbi) might be a nicer and cleaner solution.
A slicer is always a good idea (incredibly useful), plus something I really started to appreciate recently was how if you have two graphs next to each other for example in a report (for example's sake), then if you were to click the "female" component it will transform the graph next to it to only show the female data.
Depending upon what your purpose or aim with the data visualisation is; it might be just as easy to simply visualise all, Legend it by Gender as so "Male" & "Female" show their % amounts. Just some ideas, I feel SqlJason is on the right path/might already have the solution.
- SqlJason9 years agoMemorable Member
I think I got the issue. In the second approach, use only the TestAll measure on the values, and the GenderAll[Gender] on the axis. I think you kept all 4 measures on values and nothing on axis.