How filter a data stacked column with button shape ?

[Anonymous]

Hi all,

I'd like to know how can i filter a data in a stacked column using data segmentation. This is my database and visual: 

How can i filter just DEC_CJ or FEC_CJ using a filter like a data segmentation (selection box).

I tried to use but this was the result:

I want a selection box (Dec_CJ or Fec_CJ only) not a slider.

Thank you

att,

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Do you want to get the slicer like below?

If it is, you could unpivot your columns DEC_CJ and FEC_CJ in Query Editor.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Do you want to get the slicer like below?

If it is, you could unpivot your columns DEC_CJ and FEC_CJ in Query Editor.

Best Regards,

Cherry

[Anonymous · Accepted solution]

Thank you @v-piga-msft I already solved using a measure:

I created a table with only DEC_CJ and FEC_CJ values for filtering and created a new measure

if(selectedvalue([DEC_CJ]) = "DEC"; sum(DEC_CJ); if(selectedvalue(FEC_CJ) = "FEC"; sum(FEC_CJ); blank() )

something like this.

But your answser should solve the problem too.

Thanks very much for support.

Att,