Icon Data Vizualisation

[dofrancis3]

Dear colleagues us you can see, i would like to display may data by services and days of availability of Doctor.

Could you help me how to do it with DAX Mesure or calculate colomns.

Thank you

[Irwan · Accepted solution]

hello @dofrancis3 

please check if this accomodate your need.

1. original data

2. unpivot data

3. to extract type of service, go to Add Column -> Extract -> Before Delimiter (use "_" as delimiter). 

Dont forget to select the 'Attribute' column.

4. to extract day, go to Add Column -> Extract -> After Delimiter (use "_" as delimiter)

Dont forget to select the 'Attribute' column.

5. use Matrix visual and drop down your column

6. go to value, choose conditional formating, select icon

7. in conditional formating window, here is the view

- choose "Icon only" in Icon layout for showing icon (no number shown).

- use = value

- put 1 in value box as your data put 1 as available services.

- and dont forget to change into number (your data use number)

- choose symbol you want.

8. here is the result.

Hope this will help.

Thank you.

[dofrancis3]

Dear @Irwan Irwan thank you for this great job you did.

Please could you tell me what coloms shoud i unpivot data and what kin of unpivot below should i select?

[dofrancis3]

Dear @Irwan please could you share the (.pbix) file