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.

 

 Month-> 
Measure201601201602
Actual10001150
Forecast9501000
Budget10001000

 

Thanks,

Amit

Need Help

5 Replies

  • 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

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    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-values-on-rows-instead-of-colum

    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's avatar
      TomMartens
      Super User
      9 years ago

      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 :smileyhappy:

       

      Cheers