Forum Discussion
Helper IIHow to Expand Stacked Bars To fill Visual Pt2
Hi caplogic ,
Here is the PBIX.
Let me also advise to you to take the learning paths because they can really help you start and get the main concepts.
https://www.microsoft.com/en-us/power-platform/products/power-bi/learning
https://learn.microsoft.com/en-us/training/browse/?products=power-bi
Helper III have provided a link to the PBIX
https://drive.google.com/file/d/1WKCLRJrXFmT9DMj_xgyQK-4ahuK0yGDt/view?usp=sharing
Super UserHi caplogic ,
Since you are using several measures this automatically joins them has an histogram.
Adding to the great answers that pcoley gave you can also do the folllowing:
- Add a disconnect table with the name of the measures
- Add a new measure with the following code:
Chart Value =
SWITCH(SELECTEDVALUE(KPIS[Sort]),
1, SUM(AcctHdlrAnalyisByPlyAndBdrRoot[TotalGrossPremium]),
2, SUM(AcctHdlrAnalyisByPlyAndBdrRoot[TotalNetPremium]),
3, SUM(AcctHdlrAnalyisByPlyAndBdrRoot[AverageGrossPremium]),
4, SUM(AcctHdlrAnalyisByPlyAndBdrRoot[AverageNetPremium]))Now use the Measure column on X-axis and the Chart Value measure on the values
If you allow me I suggest that you check the best practices for the usage of implicit measures vs explicit measures:
https://data-mozart.com/understanding-explicit-vs-implicit-measures-in-power-bi/