Forum Discussion

kukszi's avatar
kukszi
Helper I
3 years ago

Using measure as a slicer

Hi there,   I'd like to create a measure for price ranges that I can use as a filter criteria in a slicer or to show the price distribution in a chart. The approach I try to do is the following: ...
Need Help
kukszi's avatar
kukszi
Helper I
3 years ago

Hi TaylorPBI21 ,

 

I saved the sample report to this link: Market Analysis_sample_data.pbix. The time frames and the last year comparisons won't work for now as I am including only one month of data.

 

Basically the volume (data - Volume) and the value (data - RV) tables are not directly connected to each other, but both of them are connected to the product master data table (param - ProductHierarchy - SKU) tab. 

 

The Average Price measure is calculated from the RV and the Volume measures.

 

What I'd like to achieve is to make the "Price Tiers" slicer and the "Volume by Price Segment" pie chart work, and be able to filter and display the data by the price categories ($0-$15, $15-$20, $20-$25, $25-$30, $30-$35, $35+).

 

Thank you very much for your help in advance!