Ignoring Legend filter

[madscientist]

Good day all,

I currently have a stacked bar chart with two products having the following annual sales:

Product	Year 1	Year 2	Year 3
A	10	10	10
B	10	20	30

I also have a slicer setup with values that allow me to filter out products with total sales over various thresholds (e.g >$5M, >$20M, etc).

When I select >$20M on the slicer, I see both products as single bars which makes sense as their totals are $30 and $60 respectively.  However, when I bring in Year as a legend, the only bars visible in the chart are for Product B, Years 2 and 3 only.  Is there a way to ignore the product size slicer when the Year legend is applied?

The measure I am using is: product sales = if( Calculate( [sales])>=Selectedvalue (productsize_slicervalue), Calculate ([sales]),Blank())

Thanks for your insights!

[amitchandak · Accepted solution]

@madscientist , you can unpivot the date have a year in row

https://radacad.com/pivot-and-unpivot-with-power-bi

[amitchandak · Accepted solution]

@madscientist , you can unpivot the date have a year in row

https://radacad.com/pivot-and-unpivot-with-power-bi

[madscientist]

@amitchandakHi - in the underlyding dataset, year is already in a row via a calendar table (along with all other date-related attributes).

[v-deddai1-msft · Accepted solution]

Hi @madscientist ,

Try to unpivot your table like:

And you measure will work.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai