Forum Discussion

finley0726's avatar
finley0726
Frequent Visitor
11 months ago
Solved

How to lock width stacked bar chart visual

I made this visual for Google review scores using a stacked bar chart visual. There is no X axis so I'm unable to enter a minimum width. What's the best way to lock the column so it stays the same ...
  • v-pnaroju-msft's avatar
    11 months ago

    Thankyou, MasonMA , Shahid12523 for your response.

     

    Hi finley0726,

    We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

    Based on my understanding of the scenario, we followed the approach below, using a sample dataset, to ensure that the stacked bar chart maintains a constant width regardless of slicer selections:

    1. Create a helper table named SingleBar with a single row labelled All Reviews and use this as the Y-axis.
    2. Create measures such as Review Count, Review Percent and Review Label, and then build a stacked bar chart.
    3. In the Format pane, navigate to X-axis and set Minimum = 0 and Maximum = 1. Enable Data labels.

    Locking the X-axis to the range 0–1 ensures that the bar always renders at full width. The segments resize proportionally when slicers are applied, but the overall bar length remains unchanged.

    Please find attached a screenshot and a sample PBIX file that may help resolve the issue:



    We hope the information provided helps to address your concern. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

    Thank you.