Forum Discussion

SeanHopkins's avatar
SeanHopkins
Regular Visitor
1 year ago

Stacked Bar Chart - Data Format Issue

My report has a few slicers, but one is based upon a parameter group for different Analysis Types that we have.  There is a stacked bar chart on the page as well as a matrix showing the data.  When y...
Need Help
SeanHopkins's avatar
SeanHopkins
Regular Visitor
1 year ago

Hi Pavan,

Thanks for the reply!  I guess my first question is why doesn't the stacked bar chart keep the formats for the different parameter types except for what the report was saved as.

 

How would a calculation group work in this circumstance?
I have years for columns and the rows are a different field depending on the report. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi SeanHopkins,

Thanks for reaching out in Microsoft Community Forum.

Pleaae follow below to resolve the error;

1.Create a Calculation Group with calculation items for each Analysis Type (e.g., Total Gift Amount, Total Sales), specifying the desired formatting for each.

2.Apply the Calculation Group to the visual, allowing dynamic switching between measures based on the slicer (Analysis Type).

3.Format the visual to retain the correct formatting for each Analysis Type, ensuring it updates automatically when the slicer is changed.

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.