Forum Discussion
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 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,
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
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,
2 Replies
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
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,