Stacked Bar Chart - Data Format Issue

[SeanHopkins]

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 you hover over the one of years in the stacked bar chart, the information shows the year and value of the Analysis Type.  

For example, I have an Analysis Type for Total Gift Amount.  When I hover over the value, I see the 2 decimal places.  The measure calculating this amount is set as Currency with 2 decimal places as other groups use the same dataset.  I was able to use the following to set format in the stacked bar chart visual:

I change the Analysis Type slicer to another Analysis Type and set the format for that value as well if it is needed.  I can do this for the 8 different Analysis Types that I have if it is necessary.  However, when I save the report, exit the report, then reopen the report, the only format that is still saved is for the Analysis Type set when I save the report.  I change the slicer value to another Analysis Type then go into the same format as above and it has been blanked out.  

Is there a way for Power BI to keep all of the formats?  Not sure if this is something has to be requested or not.

[Anonymous]

Hi @SeanHopkins,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[Anonymous]

Hi @SeanHopkins,

I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.

Please continue using Microsoft community forum.

Thank you,
Pavan.

[Anonymous]

Hi @SeanHopkins,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[Anonymous]

Hi @SeanHopkins,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

[SeanHopkins]

Hi @Anonymous,

I can't add a calculation group to our model for this.
I was hoping that the visual would be able to save multiple formats instead of just saving the one that the slicer is set to when the model is saved.  I can add the other formats if I change the slicer value, but when I save the file and reopen it, only the format for the slicer value when saved is there.  I don't know if this is an enhancement that needs to be requested or an issue within Power BI.

Thank you,

Sean

[Anonymous]

Hi @SeanHopkins,

Thank you for reaching out in Microsoft Community Forum.

currently, Power BI visuals do not persist multiple conditional formatting settings across slicer values unless a dynamic formatting mechanism (like Calculation Groups or dynamic format strings in measures) is implemented.

Unfortunately, if you're not able to use Calculation Groups, Power BI will only retain the format associated with the slicer value active at the time of saving the report. When the slicer value changes, any manually applied formatting is reset, which is a known limitation.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

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.

[Anonymous]

Hi @SeanHopkins,

Thank you for reaching out in Microsoft Community Forum.

Please follow below to make Power BI retain different formatting for each Analysis Type when using a slicer:

1. Please Create a Calculation Group with custom formatting rules for each Analysis Type.

2. Apply the group to the visual for dynamic formatting based on slicer selection.

3. Use pre-formatted measures and switch between them with a slicer (Fabric/Premium).

4. Use a Switch() statement for small-scale conditional formatting.

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.

[SeanHopkins]

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]

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.