Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
The xml files consist of 3 main fields: Client ID, Description and Value. The Descrption field contains 150 different categories that I am trying to analyze by value. Some of the Descrption categories include Income, Expense, Contributions... for which I'm trying to show the value by Client ID sorted from large to small or in a pie chart. What is the best way to do these 3 independent visulaizations on 1 page. I've tried creating 3 charts by applying filters to Description but when I click on 1 chart, the others change. I know this can't be that hard but I think I just have excel pivot table on my mind. Thanks for the help.
Hi @BDB,
It seems that you want to analyze the Description field with mutiple categories?
Could you share some data sample which could reproduce your scenario. Maybe we could change the data model in Query Editor first then create the visual.
I would appreciate it if you also could show your desired output.
Best Regards,
Cherry
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |