Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I have created a clustered column chart which has Divisions on the Axis and Volume in Values. The graph is filtered by slicers (I am using Period, Division and Region dimensions for the same).
I am trying a add a Total Bar in the same chart as shown below, which should get filtered by the slicer selections.
I have tried creating a measure as given below, but it does not work for the selection made using the slicers.
Regards
Viraj
Hey @VIrajMP ,
basically, it's not possible to show axis labels that are not present in the column.
To overcomes this, you have to either to think out of the box, and create an "other" member as shown in this article: https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/
You can adopt this to show the total instead of the other.
Another approach is to use visuals that provide the feature of showing a Total like the Zebra BI Charts custom visual available from the Appsource custom visual store (be aware that additional licensing fees may be necessary):
Hopefully, this provides some new ideas on how to tackle your challenge.
Regards,
Tom
Hi @TomMartens ,
I will surely try and figure out as per your suggestion. Will also check the Zebra Bi Charts to see if it suffices my requirement.
Will get back once I find something close to what I want to achieve.
Thanks a lot for your reply
Regards
Viraj
Hi @VIrajMP ,
I suggest you create a new calculated table:
x = UNION(VALUES(Regional_Forecast_Actual_Table[Division]),ROW("Division","Total"))
Then create a new measure :
Measure = VAR A = MAX(x[Division]) RETURN IF(A <>"Total",CALCULATE(SUM(Regional_Forecast_Actual_Table[MT Regional Forecast]),Regional_Forecast_Actual_Table[Division] = A),CALCULATE(SUM(Regional_Forecast_Actual_Table[MT Regional Forecast]),ALLSELECTED(Regional_Forecast_Actual_Table)))
Use Division column in calculated table for x-axis and measure for value.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
117 | |
85 | |
49 | |
38 | |
28 |
User | Count |
---|---|
189 | |
76 | |
73 | |
54 | |
42 |