Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Grey out Total bar in Stacked chart

    Bronze Contributor
    Posted 11 days ago

    In my slicer I have Page 1, Page 2 and default as all in the slicer:

    If all is selected from the slicer, we should have below output (which is Ok)

    And when we select Page 1 from the slicer, we get below output:

    Is there a way, that the total bar gets greyed out if specific choice is selected from the slicer.
    In the above screen shot, the red color bar should get greyed out.

    Please advise.

    Prem Guru

  • 2.  RE: Grey out Total bar in Stacked chart

    Posted 10 days ago
    Hi Prem,

    I believe your question can be solved with a DAX calculation measure. There are options to ignore all filters which would provide you with the real totals bar (it won't gray out though).

    Here's an example: Solved: A DAX measure to ignore specific Filter. - Microsoft Power BI Community

    Can you share more detail of your source? Maybe share a simplified version of it so that I/someone else can test this theory?

    Erik v H.

    Erik van Hurck
    consultant / Content creator