Anonymous's avatar
Anonymous
Not applicable
3 years ago
Status:
Needs Info

Highlight selected values in filters

Hi there!

 

I want put a highlight bar in a filter, when it's a value selecting.

But the highlight only works in the filter, when I selecting values in other filter!! Very weird ><'

Please, can somebody help me?

 

Here below, how I configurated the filter:

 

1-First, I created the DAX condicional:

 

Regra Filtro = 
VAR RegistrosTT =  
    CALCULATE(
        COUNT( Tabela[SEMANA] ),
        ALL( Tabela[SEMANA] ))
VAR Registros = COUNT(Tabela[SEMANA])
RETURN
IF( Registros = RegistrosTT, 0, 1 )

 

 

2-With filter selected I went to Options menu -> Effects -> Shadow and click in Condicional format color.

 

 

3-Then I choose Rules -> the condicional DAX "Regra filtro" and formated the criterions as I want.

3 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

    I tried to restore the scenario you mentioned but failed, can you provide your pbix file for reference ?

     

    Best Regards,
    Community Support Team _ Ailsa Tao

     

  • Anonymous's avatar
    Anonymous
    Not applicable

     

    Hello Anonymous !

     

    Thank you to return.

    I don't find a icon to attachmenting here, so I put in a Google Drive folder.

     

    Here is the link :PBI_Community Folder