Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |