Forum Discussion
Conditional Formatting with Field Parameter using Filled Map in Azure Map visualization
Anonymous
Thank you! Actually, I just needed that measure. This is the idea I had. Using your measure, the resulting map looks right. Do you see a potential problem?
Your measure:
Measure = SWITCH( SELECTEDVALUE(Parameter[Parameter Fields]), "'Table'[Employee]", SUM('Table'[Employee]), "'Table'[Amount]", SUM('Table'[Amount]) )Next Steps:
Turn off Bubble Layer > Turn on Filled Map > Colors > Conditional Formatting > Format Style = Gradient > Base on = Measure > Adjust color, Min, Max
Result:
Hi user01 ,
I am not able to implement color gradient in Azure map visual object, below is the test result of displaying Amount, Employee values of different categories in Azure map based on the value selected by slicer after I created the field parameter.
Created a measure.
Measure =
SWITCH(
SELECTEDVALUE(Parameter[Parameter Fields]),
"'Table'[Employee]", SUM('Table'[Employee]),
"'Table'[Amount]", SUM('Table'[Amount])
)
Drag the State field to the location of the Azure map and drag the measure to the size.
Now you can choose the value you want based on the slicer.
The pbix file is attached.
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Anonymous
Thank you! Actually, I just needed that measure. This is the idea I had. Using your measure, the resulting map looks right. Do you see a potential problem?
Your measure:
Measure =
SWITCH(
SELECTEDVALUE(Parameter[Parameter Fields]),
"'Table'[Employee]", SUM('Table'[Employee]),
"'Table'[Amount]", SUM('Table'[Amount])
)
Next Steps:
Turn off Bubble Layer > Turn on Filled Map > Colors > Conditional Formatting > Format Style = Gradient > Base on = Measure > Adjust color, Min, Max
Result:
Hi user01 ,
Thanks for the reply from BIswajit_Das .
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
I can open BIswajit_Das's pbix file, his pbix file is attached, you guys are on the same page.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!