Visuals using count from multiple columns

[acrinard]

I currently have data from a SharePoint list of requests displayed in a single table (Table 1). Important columns that I need to use in visuals include Request ID, Request Date, and 10 "tag" columns that are used to tag the request topic (Tag 1, Tag 2...Tag 10). Each request can have multiple tags and each tag can appear in any of the tag columns.

I need to create visuals that display the relative frequency of each tag, for example a pie chart that displays how often each tag appears across the total request ID count. I also need to be able to filter the whole report, including these visuals, by request date.

Because I can't reference multiple columns in a single visual, I thought I could create a separate table (Table 2) with rows representing each possible tag and a single column that counts how many times that tag appears in Table 1. But basing visuals off of Table means I can't filter by date because the table wouldn't be related to Table 1.

Any ideas on how I can do this?

[lbendlin · Accepted solution]

 Important columns that I need to use in visuals include Request ID, Request Date, and 10 "tag" columns that are used to tag the request topic (Tag 1, Tag 2...Tag 10).

In Power Query unpivot the tag columns.

[v-kpoloju-msft · Accepted solution]

Hi @acrinard,

Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to personally thanks @lbendlin, for actively participating in the community forum and his inputs.

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used it as sample data on my end and successfully implemented it. Therefore, please refer to the attached pbix file.

I hope this should resolve your issue, if you need any further assistance, feel free to reach out.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Best Regards.

[v-kpoloju-msft]

Hi @acrinard,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @acrinard,

We have not yet received a response regarding our previous reply and would like to check if your issue has been resolved. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @acrinard,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[lbendlin · Accepted solution]

 Important columns that I need to use in visuals include Request ID, Request Date, and 10 "tag" columns that are used to tag the request topic (Tag 1, Tag 2...Tag 10).

In Power Query unpivot the tag columns.