Forum Discussion

amitnhpBI's avatar
amitnhpBI
Frequent Visitor
9 years ago

Measure one below another

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.   ...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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's avatar
    amitnhpBI
    Frequent Visitor
    9 years ago

    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's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      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