Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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 ><'

Capturar2.PNGCapturar3.PNG

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.

Capturar1.PNG 

 

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

Capturar4.PNG

Status: Needs Info

Hi @malmeida 

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

 

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

Hi @malmeida 

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

 

malmeida
Regular Visitor

 

Hello @v-yetao1-msft !

 

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 

 

 

malmeida
Regular Visitor

Hello @v-yetao1-msft !

 

Did you accces the pbix in Google drive?