Is it possible to use slicer selections as measure inputs?

[Anonymous]

Hi Folks, 

The Power BI report I'm working with pulls from Azure Analysis Services. I cannot add calculated columns, add tables, enter data, or use the query editor. I did not create the model and I don't have acces to the model. 

I wanted to know if it is possible to use a slicer as the input for a measure. For example, I made two slicers called Slicer 1 and Slicer 2. Is there a measure that can filter any item selected from Slicer 1 and add the item's value to the value for any item selected in Slicer 2? I should mention that I need to populate line charts which show seperate lines, one for each the two item's sales performance over the selected time period.

I'm pretty sure this is not possible, but since I can't create tables or columns I wanted to see what options are available.

The items for both slicers would come from the same column. 

[v-yingjl · Accepted solution]

Hello @Thalia ,

As mentioned, you cannot use a measure to filter slicers in power bi when you connect to the AAS model because you cannot create columns or calculate tables.

Best Looks,
Yingjie Li

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

[amitchandak]

@Anonymous , To make slicer work on the measure, you need to have an independent table having all measure values or measure values as a range like a bucket and then you need join with this table in another measure to make sure slicer from this table works.

Refer to my video if that can help : https://www.youtube.com/watch?v=CuczXPj0N-k&t=401s

or these two

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Anonymous]

Hi

Thank you for your response! I'm actually not able to create tables or columns because I'm connected to an AAS model.

[vivran22]

Hello @Anonymous ,

Can you show the output required with some sample data?

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter

[Anonymous]

I'm not able to share the report because it's linked to my work account but here's a screenshot of what I want to do. I want the end user to be able to select from any item in ItemSlicer1 and Item Slicer2 and have the visuals update along witht heir selection.