Data Visual Suggestions

[BIswajit_Das]

Hello Guys,

I need suggestions on data visuals for the below attached data structure;
Requirements : Need to identify the area explored by candidates.

BOOTH NO.	PS	Area	WARD	CANDIDATE	DATE
1	Govt. Primary School, Haibowal Kalan (EW)	1. Pavittar Nagar,Walia Colony Haibowal Kalan	63	SA	4/16/2025
1	Govt. Primary School, Haibowal Kalan (EW)	2. Pavittar Nagar Main Gali (Part 1)	63	SA	4/16/2025
2	Govt. Primary School, Haibowal Kalan (WW)	1. Haibowal Kalan (Part 1)	65	BBA	4/16/2025
2	Govt. Primary School, Haibowal Kalan (WW)	2. Guru Nanak Dev Nagar	65	BBA	4/17/2025
3	Govt. Primary School, Haibowal Kalan (NW)	1. Haibowal Kalan (Part 2)	65	BBA	4/17/2025
4	Govt. Primary School, Haibowal Kalan (SW)	1. Pavittar Nagar Main Gali (Part 2)	65	SA	4/17/2025

I've already tried the matrix visual as heat map but not statisfied with the result. So any other suggesstions might be usefull.
Note : If possible want to display all the area/booths in a single visual with any sliders

Thanks & Regards
Biswajit

[v-achippa]

Hi @BIswajit_Das,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue?
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[BIswajit_Das]

Hello @v-achippa,
As I mentioned above I need suggestions on data visuals and @Akash_Varuna's suggestion is really helpful but using Treemap is a little complex to visualize data cause I've got 200 rows which makes it unreable so I need more options.
Thanks & Regards...

[Akash_Varuna · Accepted solution]

@BIswajit_Das Could you try using a Custom Map Visual with "Area" as markers and filters for "Candidate" and "Booth No."? Adding a date slider could help explore specific timeframes interactively.

[BIswajit_Das]

Hello @Akash_Varuna

Thanks for your responds I've also tried Custom Map but need a custom JSON for it.
E.g

I have 200 rows so here i need 200 boxes like a heat map

Thanks & Regards...

[Akash_Varuna]

Hi @BIswajit_Das You could try using a Treemap with Area as the hierarchy and Candidate or Booth No. as categories to visualize the distribution of explored areas.