Measure one below another

[amitnhpBI]

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

[TomMartens]

Hey,

you are not alone, but luckily there is an idea

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-value...

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 ...

[TomMartens]

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

[v-huizhn-msft]

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

[amitnhpBI]

Thanks for your response but client is very specific on the format. Its very easy to get that format in other reporting tools.

[v-huizhn-msft]

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