The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
57 | |
54 | |
53 | |
47 | |
31 |
User | Count |
---|---|
175 | |
88 | |
69 | |
48 | |
47 |