Forum Discussion
Power BI Dashboard - Source file format
Hi! I been using Power BI for last couple of months. When I start to create dashboard in Power BI for one of the table format I was not able to fix the issue. It would be very helpful I you could hel...
Hi!
Thanks for your reply.
Thats what exactly I mean.
Below is the link for excel file format with the graph. I would like to create the chart in power BI without changing the table format.
Thanks
v-piga-msft
Resident Rockstar
Resident RockstarHi Anonymous ,
For your table format, I'm afraid that we cannot create that chart in power bi.
As a workaround, you could duplicate the original table and then Unpivot the date columns for the table 2 in query editor so that you could get the date column as the x axis for the clustered column chart.
In addition, I have a little confused about the Sales 14 and Sales 13, it seems that there is no column named Sales 14 and Sales 13 in your table format.
Best Regards,
Cherry
Thanks for your reply! But I don't want to change the format.