Forum Discussion

cmorris_afca's avatar
cmorris_afca
Frequent Visitor
6 years ago

Conditional Formatting not working when a filter is applied

Hello,

I have created a two cards and added conditional formatting to the 'data label' and 'title' so that they are black or white depending if they should be visable or not, this allows me to overlay the visuals and display one or the other depending on a value that is selected on a slicer.

I then have a need to apply a filter to the visual and the results in the conditional formatting not working, so I see both cards together.

Does anyone know why this happens? Why is the filter stopping the conditional formatting?

 

Regards,

Carl

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    I am hopeful, that the new value of cart/color formatting filed, after filter is, covered under conditional formatting. Can you share calculation and foamtting rules.

    • cmorris_afca's avatar
      cmorris_afca
      Frequent Visitor
      6 years ago

      Hi,

      I have tried that and it works fine when there is no filter applied and the user selects the requirements via the slicer.

       

      The issue is I have a large set of data that comes into my model and depending on the card, a filter needs to be applied so that only the required figures are displayed. The user then uses the slicers to select the required month/user/team. These work fine seperatley but when I have both a filter (which is static) and a slicer the conditional formatting does not work.

       

      Regards,

      Carl

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago
         
        It may be difficult to fully meet your needs.
        Could you please share sample pbix and DAX formula? We can think about other alternatives.
         
        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    I have the same problem,

     

    when there no filter enabled, I can set to transparency via conditional formating the x ticks, grid, background and title.

    but when I select a filter to show only when a encoder is 0, this graph data disappear but all the transparency is lost.

     

    Can't find any solution or why this is happening. I have other 3 graphs that work in same .pbix