I need Below image type Matrix reports

[Aruna_ln]

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 help me.

this type of report i have 5 report.please help me

[san_jois]

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