Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Financial reporting challenge in matrix object

Hi,

I'am facing following challenge. I need to make following report which contains mixed of measure and dimension. Please see the specs on the picture:

 

We have measures actual, budget and forecast. Actual and forecast are in one measure. We would like to show that measure with months, but then rest of measures with diffenrent dimensions. How I should progress with this?

 

The problem is that matrix will automatically group values by column, but I want that some values only do that. Like CY vs. PY (Current year vs. Prev Year) doesn't split by months.

 

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

    >> Like CY vs. PY (Current year vs. Prev Year) doesn't split by months.

    Nope, current you can't direct do customize on matrix column group. Maybe you can try tp submit this requirement to idea forum.

    In addition, you can also try to use group feature to create a custom group column based on your requirements if it works:

    Use grouping and binning in Power BI Desktop

    Regards,

    Xiaoxin Sheng