Forum Discussion

user01's avatar
user01
Resolver I
1 year ago
Solved

Conditional Formatting with Field Parameter using Filled Map in Azure Map visualization

I have some dummy data below. EDIT: I uploaded an Excel workbook to Power BI, but the real data will be coming from SQL Server via DirectQuery. The solution must work with DirectQuery.   I want to ...
Need Help
  • user01's avatar
    user01
    1 year ago

    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:

     

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
1 year ago

Hello user01 , Anonymous 
As per user01 requirement by using Anonymous measure DAX the visual can be modified. You can check the below attached file to check.
File Link : https://ufile.io/xsaom5o8

Thanks & Regards ...