Forum Discussion
Sales by mounth from one table
Hi everyone, I am new to the BI world, so excuse me if my question is poorly formulated and that the question might be simple. I have created a Microsoft PowerApp in which various data are be...
MFelix
Super User
Super UserHi Anonymous ,
When you are refering that each value has it's own field I'm assuming that you have a column for each of the month (Jan2020,Feb2020,....Dec2020) correct?
You need to unpivot the months columns and then use a calendar table to wrap everything in your visuals, but without any data example or expected result is difficult to give you a better answer.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).
Regards,
MFelix