topic Icon Data Vizualisation in DAX Commands and Tips

Icon Data Vizualisation

dofrancis3 — Mon, 14 Oct 2024 23:51:38 GMT

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 — Tue, 15 Oct 2024 02:18:35 GMT

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 — Tue, 15 Oct 2024 10:32:09 GMT

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 — Tue, 15 Oct 2024 11:51:36 GMT

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