Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How filter a data stacked column with button shape ?

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 li...
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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's avatar
    Anonymous
    7 years ago

    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,

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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,