Forum Discussion

ryan12345's avatar
ryan12345
Frequent Visitor
4 months ago
Solved

Multiple measures in matrix by year

Hi all,   I am trying to create a matrix that mirrors the screenshot excel example below, where the 4 measures (actual, contract, variance & % attainment) are shown individually by year with a spac...
Need Help
  • danextian's avatar
    danextian
    4 months ago

    Hi ryan12345 You’ll need to set up a disconnected table that includes all combinations of years and measure names, along with additional rows to represent blank columns. You can then use the columns from this table in your model (without creating relationships to fact tables). For the blank columns, return a zero value, but apply a dynamic format string so they are displayed as spaces instead of zeros. Write another measure for conditional formatting.

     

    Please see the attached pbix.

     

     

Lodha_Jaydeep's avatar
Lodha_Jaydeep
Solution Sage
4 months ago

Hi ryan12345,

 

Somehow can you provide the sample report where you have created this measure and other stuff. If the report has any non-disclousable info you can delete the page. It will be help to assist in better way. Then will give you the updated .PBIX with the chnages you need.

 

Hope this sounds good!