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
    Hello,

    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?

    Regards,
    Erik v H.

    ------------------------------
    Erik van Hurck
    consultant / Content creator
    ------------------------------