Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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 in the map what disctrict is "high" or "low" based on the heatmap colors.

Any thoughts?

 

Thank you.

1 ACCEPTED SOLUTION

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
pbicvsupport@microsoft.com

View solution in original post

5 REPLIES 5
v-evelk
Employee
Employee

Hello,

 

I didn't get your idea. Why don't you want to achieve the same effect with "Value" bucket?

Could you explain how you see it with details?

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous
Not applicable

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!

 

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
pbicvsupport@microsoft.com

Anonymous
Not applicable

@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.

Please, try to set up levels manually.

 

Contur.PNG

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors