Forum Discussion
Displaying multiple-select questions on map legend
Thank you very much! The link to the discussion with the similar issue helped immensely. Specifically the video that the user linked https://www.youtube.com/watch?v=rI0uHdBwgPY
To summarize, I had to add the Category of Incidence as a new query (and add an index column), split it into columns, then unpivot all columns except for the index.
I have another column for Location for the x-axis. How would I accomplish this? When I try unpivoting the columns it multiplies the number of rows. Apologies as I'm new to this.
Hi bssdon ,
Thank you for your kind reply!
What does all the data you have look like? Could you please describe in more detail the output you expect to get? It's normal for you to mention "When I try unpivoting the columns it multiplies the number of rows. ", We need more information to offer you more help!
Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
In addition, someone else had a similar issue like yours before, you could check out the link, hopefully it will help you have more ideas.
Solved: Visual-level filters not working - Microsoft Fabric Community
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much! The link to the discussion with the similar issue helped immensely. Specifically the video that the user linked https://www.youtube.com/watch?v=rI0uHdBwgPY
To summarize, I had to add the Category of Incidence as a new query (and add an index column), split it into columns, then unpivot all columns except for the index.
Hi bssdon ,
I am happy to learn that you found the cause of the problem and fixed it.
Could you please accept your own reply or my reply as a solution, it will make it easier for other users who may be experiencing the same problem to find a solution.
Thank you for your understanding!
Best regards,
Lucy Chen