Forum Discussion
Stacked bar chart with two different shared axis
Hi,
I found the solution myself.
I don't need to use measures that split up the percentages already on the level of type, as I use type on the X axis.
It's enough to have the percentages per part.Percentage_Street = CALCULATE( [Percentage_KPI_ADDRESS]; F_KPI_ADDRESS[part] = "street" )Percentage_Number = CALCULATE( [Percentage_KPI_ADDRESS]; F_KPI_ADDRESS[part] = "number" )Percentage_Zip_Code = CALCULATE( [Percentage_KPI_ADDRESS]; F_KPI_ADDRESS[part] = "zip code" )Percentage_City = CALCULATE( [Percentage_KPI_ADDRESS]; F_KPI_ADDRESS[part] = "city" )
These 4 measures I use as Values respecively as street, number, zip code and cityand on the Axis I use month and type.
And drill down with
The result is exactly what I wanted
Hi,
I found the solution myself.
I don't need to use measures that split up the percentages already on the level of type, as I use type on the X axis.
It's enough to have the percentages per part.
These 4 measures I use as Values respecively as street, number, zip code and city
and on the Axis I use month and type.
And drill down with
The result is exactly what I wanted
Community SupportGlad to hear that you have solved it by yourself and thanks for your sharing your solution that it could help others quickly!
Best Regards,
Community Support Team _ Yingjie Li