Forum Discussion
Required layout in the report view
Hi Community, please refer to the attached screenshots in which the current view showing the existing view and the required view is the one we wanted in the the Power BI (I want AUM & Fees as my main headers and years as subheaders under the AUM & Fees). Please note that the AUM and Fees columns are the measures calculated in the Power BI. Kindly suggest a way out to get the required view in the Power BI Report View page.
Hi Anonymous ,
According to your description, in power bi matrix we can't use measure as columns of matrix because using mesure we need to make calculations based on context. So only different MEASURES under fiscal cycle can be implemented.
If your ultimate goal is to clearly compare different fiscal years under the same MEASURE, you can try to use a line chart for the presentation, which will make it easier for you to compare different time dimensions under the same MEASURE.
Create a matrix visual in Power BI - Power BI | Microsoft LearnCreate line charts in Power BI - Power BI | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
cath1ynnResolver II
If you're using the Matrix visual (with lots of nice custom formatting applied), you should be able to switch the fields that are currently used as the Columns such that Fiscal Period is at the top. If not, you will need to provide a sample PBIX file.
Hi cath1ynn switching the fields will not produce the desired results because the AUM & Fees are Measures which are placed uder Values tab.
Hi Anonymous ,
According to your description, in power bi matrix we can't use measure as columns of matrix because using mesure we need to make calculations based on context. So only different MEASURES under fiscal cycle can be implemented.
If your ultimate goal is to clearly compare different fiscal years under the same MEASURE, you can try to use a line chart for the presentation, which will make it easier for you to compare different time dimensions under the same MEASURE.
Create a matrix visual in Power BI - Power BI | Microsoft LearnCreate line charts in Power BI - Power BI | Microsoft Learn
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly