Multi selection in power bi

[DiKi-I]

Hi I have 2  base measure currently added in the line chart of power bi which shows daily trand. The user want the flexibilty to select , unselect moving average days based on the two base measures.

So there will be two base measures in the line chart and extra lines of moving average needs to be added based on user selection. I can add only one measure in the line chart if I'm using moving average days as legend. Can someone help me how i can implement this?

[v-dineshya · Accepted solution]

Hi @DiKi-I ,

Thank you for reaching out to the Microsoft Community Forum.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

[v-dineshya]

Hi @DiKi-I ,

We haven’t heard from you on the last response and was just checking back to see, Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

[v-dineshya]

Hi @DiKi-I ,

We haven’t heard from you on the last response and was just checking back to see, Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,

Dinesh

[danextian]

Hi @DiKi-I 

If there are just four moving average days measures, create those and put them in a field parameter.

Please see the attached pbix.

[DiKi-I]

Thanks but I alredy tried the above the problem is there are two base measures and if I use field parameter there will be 8 selections in field paarmeter. I just want the user to have four slections. In your case you have used actual if you add one more base measure there will be 8 selections.

[danextian]

Did you want to add apply moving averages to those two base measures? What is your expected result visually?

[DiKi-I]

yes it will applied to both the base measures so that user can compare the moving average of both the two measures. MeasureA 7d MA,MeasureA 14d MA,MeasureB 7d MA,MeasureB 14d MA and so on.  But user can select and compare any moving average, for now I have 4*2 selection in slicer. I wanted to reduce it to 4 just 7, 14 ,30 & 50