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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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?