Forum Discussion

DiKi-I's avatar
DiKi-I
Post Partisan
10 months ago
Solved

Multi selection in power bi

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. ...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    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

DiKi-I's avatar
DiKi-I
Post Partisan
10 months ago

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's avatar
    danextian
    Super User
    10 months ago

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

    • DiKi-I's avatar
      DiKi-I
      Post Partisan
      10 months ago

      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