Forum Discussion
Aruna_ln
8 years agoHelper III
I need Below image type Matrix reports
HI all, My data source is SSAS,all data comming from SSAS below image format i need report how to create below format report or any custom report availble in forum? please any body he...
san_jois
8 years agoResolver I
Pls send me your PBIX file or share the same through dropbox
I think you should hae two tables arranged either in the SSAS source or in PBIX
One should be daily data where DailyDate and Bill Amount are two columns
Another table should be a consecutive daily calender called eg. dCalender. Let this table have dCalenderDate, Year, Month, Day
You can generate the same easily and connect dCalenderDate with DailyDate of daily data table
Select a Matrix visual
For rows, choose Name from Daliy Data table
For columns, choose the following in the same sequence
Month-Year-Bill Amount
And in values choose Bill Amount
That should work
Hope it helps