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.
Hello,
How can I create following report in power bi.
1. Report One
2. Second Report
Please provide your valuable suggestion
Regards,
Sandeep Bhaduairya
Solved! Go to Solution.
Hi Sandeep,
For complete Time intelligence Patterns in DAX, Please refer to this blog by Marco Russo and Albero Ferrari at here. This will give you the idea of how to create all the measures shown in your Reports.
Hi devssolution,
In general, the basic steps to generate the report in Power BI should be:
1. Get the fact Data;
2. Create reference table (such as date table) or measure to help building the report;
3. Choose the Visual;
To get the actual data, we should make sure we could import the data into Power BI (Desktop), check: Data sources in Power BI Desktop;
For the measure, as suggested by BhaveshPatel, requires time functions in DAX. DAX have the function to calculate the total sales based on dates, like MTD, QTD or YTD.
In addition to the blog already shared, please also take a look at the following one, which explains different kinds of date and time functions:
Time Intelligence Functions in DAX
The reports style you posted could be accompulished through table or Matrix Visuals in Power BI:
How to Use Tables and Matrixes
If you need any further assistance on this, please post back.
Regards
Hi devssolution,
In general, the basic steps to generate the report in Power BI should be:
1. Get the fact Data;
2. Create reference table (such as date table) or measure to help building the report;
3. Choose the Visual;
To get the actual data, we should make sure we could import the data into Power BI (Desktop), check: Data sources in Power BI Desktop;
For the measure, as suggested by BhaveshPatel, requires time functions in DAX. DAX have the function to calculate the total sales based on dates, like MTD, QTD or YTD.
In addition to the blog already shared, please also take a look at the following one, which explains different kinds of date and time functions:
Time Intelligence Functions in DAX
The reports style you posted could be accompulished through table or Matrix Visuals in Power BI:
How to Use Tables and Matrixes
If you need any further assistance on this, please post back.
Regards
Hi Sandeep,
For complete Time intelligence Patterns in DAX, Please refer to this blog by Marco Russo and Albero Ferrari at here. This will give you the idea of how to create all the measures shown in your Reports.
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 |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |