Forum Discussion
RanHo
4 years agoHelper V
Power Bi Visual - Trend
Good day! I want to create a Trend dashboard wherein it records the everyday data gather and also it will reflect and appear to a visual according to data and date. As you can see on my example th...
amitchandak
4 years agoSuper User
RanHo , remove the second row and load this data. And tranpose the data in power bi and then use it power bi
or unpivot the dates
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
- RanHo4 years agoHelper V
amitchandak I'll try it Sir, but I have a question , although I have server is it possible to generate those columns per day in PowerBI or like is there a storage or table i can generate that kind of columns with count of data??
-Ran