Forum Discussion

Aruna_ln's avatar
Aruna_ln
Icon for Helper III rankHelper III
8 years ago

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

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

Need Help

1 Reply

  • san_jois's avatar
    san_jois
    Icon for Resolver I rankResolver I
    8 years ago

    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