Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Map filtering with variables

Hello,   I want to create a heatmap in powerbi desktop where the map changes when the variable changes. For example, i want in the filter to select either volume of sales or value of sales and see ...
  • v-evelk's avatar
    v-evelk
    6 years ago

    Ok, got it!

     

    You can try to add new group column in your dataset and use it in a Chiclet Slicer visual , for instance, to filter your dataset. 

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello v-evelk ,

 

My task is to create a map where the user can select a variable from the filter widget. The map will change colors based on the variable the user selected. 

Can i put variables in filter widget instead of values from a single variable?

 

I hope my answer is clear now.

 

Thank you!

 

v-evelk's avatar
v-evelk
Microsoft Employee
6 years ago

Ok, got it!

 

You can try to add new group column in your dataset and use it in a Chiclet Slicer visual , for instance, to filter your dataset. 

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-evelk  Thank you for your answer.

     

    Indeed it worked but when i choose a variable from the slicer the size of the bubble in the different cities does not change because i can not put sizing in the map.

    • v-evelk's avatar
      v-evelk
      Microsoft Employee
      6 years ago

      Please, try to set up levels manually.

       

       

      Kind Regards,

       

      Evgenii Elkin,
      Software Engineer
      Microsoft Power BI Custom Visuals
      [email protected]