Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Hide stacked row when below threshold

Hi, In the charts below I am willing to hide the row when the row value goes below 50. For the right hand chart, I can do it by using measure in this format: IF([measure] > th...
Need Help
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous  to get the desired result you need to use measures to break down the stacked.

    For example, in my data set, I have a sales.

    So the measures will be :

    Total sales (K/$) = SUMX('orders',('orders'[Unit price]- [Discount])*'orders'[Quantity])
    total sales LY = CALCULATE([total_sales],SAMEPERIODLASTYEAR('Calendar'[Date]))
    Result before filtering :

    The result after filtering sales greater than 200,000

    pbix is attached

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

     
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks Ritaf1983 

I checked your pbix.

I can see you have two segments in the stacked chart, but in my case the measure is stacked by a dimension. When I apply the same principle in your pbix, unfortunately it does not work 😞

I think when stacked by, it considers the part of the bar to meet the condition set.

 

Ritaf1983's avatar
Ritaf1983
Super User
2 years ago

Hi Anonymous 
As I mentioned that is possible only if you will create separate measures...

This is how the engine works, you can't filter a "part of the measure"

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