Power Bi Visual - Trend

[RanHo]

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 the label "01-New Claim" might become "07-For Unit" or any other number labels  if process is proceeds, therefore the data from 01 will go to 07 and will add to its count.     Can you guys tell me how to do it , or can you give me an example so that I can have a better idea how to do it.

Thanks in advance!

-Ran

[amitchandak]

@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/

[RanHo]

@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