Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a set of three categories under each month and would like to get the total of each category over a year to show on a visualization as one value. I would do this by grouping in Tableau, maybe even in Power BI desktop, but I do not see the option to do it in the online program. How do I format my excel worksheet so that it recognizes that march, april, and so on, all had the same categories, but I want to combine them? Here is what I mean. the original data showed the month above each category, but Power BI didn't like importing that either.
We cannot do modeling in Power BI services. So if you want to group your categories under each month, you could use a martrix visual, and add month to your columns. Or you could connect your data source in Power BI desktop, reshape your data model. And then create your reports and publish to Power BI services.
Regards,
Charlie Liao
Thank you, but unfortunately, I am specifically looking for a solution to the online version. I have simply resorted to creating many columns in my worksheet.