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,
I'm trying to develop a Power BI report as per below report that could show Current Vs Last Week Milestones Dates. I have tried several visuals in power BI desktop but still struggling with a solution. Need to know which visual i should use to develop similar kind of report in power bI and how source data should be built up.
I have also attahced sample excel file below for the type of data i have for this report. Could anyone guide me in this regards?
Thanks
Solved! Go to Solution.
Hi, @aliawais
I doubt whether the default visual can do it. You can search for possible working visuals in the AppSource.
The following three visuals seem to be close to this topic, and you can test them in your model.
Inforiver Professional Matrix / Table
Inforiver Standard Matrix / Table
In a data model where you need to unpivot the current week and last week columns, you can unpivot the columns under the transform tab in Power Query
Your data may look like the following in the end.
Based on the above, you can test whether you can get the desired result.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks alot for your response. I'll test these visuals 🙂
Hi, @aliawais
I doubt whether the default visual can do it. You can search for possible working visuals in the AppSource.
The following three visuals seem to be close to this topic, and you can test them in your model.
Inforiver Professional Matrix / Table
Inforiver Standard Matrix / Table
In a data model where you need to unpivot the current week and last week columns, you can unpivot the columns under the transform tab in Power Query
Your data may look like the following in the end.
Based on the above, you can test whether you can get the desired result.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |