Forum Discussion

dia612's avatar
dia612
Icon for Helper IV rankHelper IV
6 years ago

Visual Used for MAP

Hello, I have come across this visual online which visual is used to get this ?? I have tried Shape map but I am not able to display the state name& % in shape map like in this visual.
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi dia612 ,

 

You may create calculated column like DAX below, then put it into Location box of Filled Map.

 

State Percent =
Table1[State] & " "
    & ROUND (
        DIVIDE (
            CALCULATE ( SUM ( Table1[Amount] ), ALLEXCEPT ( Table1, Table1[State] ) ),
            CALCULATE ( SUM ( Table1[Amount] ), ALL ( Table1 ) )
        ),
        0
    ) & "%"

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.