Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello everyone,
I'm trying to add a total bar to the clustered column chart.
Here is my Fact Table:
Here is the Channel Table created and I set up the relationship between the two tables using Channel:
And below is the YoY% measure I created and trying to add to the visual:
However, I'd like the TOTAL to be displayed as the last column, and when I sort the Channel by Order, the TOTAL disappear from the visual:
I'm not sure if it's a bug or I miss anything. Any suggestions would be appreciated. Thanks.
Solved! Go to Solution.
Not sure what I did differently but perhaps you can reverse-engineer the .pbix file I attached, I simply re-created your tables and solved the problem from the bottom up.
Here's the measure I ended up using.
Not sure what I did differently but perhaps you can reverse-engineer the .pbix file I attached, I simply re-created your tables and solved the problem from the bottom up.
Here's the measure I ended up using.
Brilliant, it works!
btw I also found I should change my formula to:
YoY % = IF(SELECTEDVALUE('Channel Table'[Channel])="TOTAL",CALCULATE(DIVIDE(SUM(Fact_Table[TOTAL CY])-SUM(Fact_Table[TOTAL LY]),SUM(Fact_Table[TOTAL LY])),ALL('Channel Table'[Channel])),DIVIDE(SUM(Fact_Table[TOTAL CY])-SUM(Fact_Table[TOTAL LY]),SUM(Fact_Table[TOTAL LY])))
and then it works too.
Thanks for your help!
User | Count |
---|---|
97 | |
78 | |
77 | |
48 | |
26 |