Help: creating a category depending the data sheet from where the information comes

[RicardoNeri]

Hello guys

I´m trying to make a radial chart instad of having a lot of  gauges to show the same information and to be a lot friendly to the user. like a sportman to know in which area is he weaker. For example the gauge named horarios shows the average % of the progress of each day to give us a score for each member, "that would be one category of the radial chart" another category would be the score of fast food as so on, all of the results are in a 0% to a 100% . The big problem is that all the information comes from a different data source so I dont have an unified category label.

The question is: how can I create an unified data sheet that gives me a category depending where the info comes? also all the data sheets have the same pivot that is the code of the store, do you think showing this kind of information in a radial chart its a good idea or should I leave it as it is?

Thanks a lot for your time!

[v-rongtiep-msft · Accepted solution]

Hi @RicardoNeri ,

I have found some helpful links, please refer to.

Solved: Create one unified dataset? Or Link separate datas... - Microsoft Power BI Community

Creating the Unified Dataset for Categorization (tamr.com)

Data categorization in Power BI Desktop - Power BI | Microsoft Learn

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.