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 have a basic requirement to show one measure below another measure as shown below . Can anyone help me how to achieve this in Power BI. I tried using Cross tab report but didnt worked.
Month-> | ||
Measure | 201601 | 201602 |
Actual | 1000 | 1150 |
Forecast | 950 | 1000 |
Budget | 1000 | 1000 |
Thanks,
Amit
Hey,
you are not alone, but luckily there is an idea
with a lot of votes and the Power BI already started working, but of course there is no ETA. Personally I hope that it will be coming soon. This is of the most often asked features and personally I think this is a utterly basic reporting feature.
But it is in the works, so sooner or later ...
Just to let you know, that with the current release of Power BI Service it is possible to make this happen:
Now let's our fingers crossed that it will come also to the next Power BI Desktop release
Cheers
Hi @amitnhpBI,
For the format you given above, we can not the same to show one measure below another measure as shown below. Because measure can not be added row level in Matrix visual. You can create a table visual, select month, Actual, Forecast, Budget as values, or you can create a matrix visual, select month as row level, Actual, Forecast, Budget as value levels, you will get the following format result.
month | Actual | Forecast | Budget |
201601 | 1000 | 950 | 1000 |
201602 | 1150 | 1000 | 1000 |
Best Regards,
Angelia
Thanks for your response but client is very specific on the format. Its very easy to get that format in other reporting tools.
Hi @amitnhpBI,
I total understand you, the format is not supported in Power BI now, you can create a idea here. Maybe it will be considered in the future.
Best Regards,
Angelia
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |