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.
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.