Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Microsoft Power BI Matrix - change individual cell value based on column total

I have a Power BI Matrix in which there are a number of measures. I have a lot of transaction level data at the back-end for each day in a month.   I have all the months in a Slicer, in which I ch...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Frank, will get back

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Frank,

 

The Matrix has only column groups; the Category column which you have assumed does not exist, i.e. there are no row groups in the matrix. There are a number of Measures (A,B,C,X,Y,Z) which are added as Values for the matrix.

 

Let me know if this can be worked out.

 

I tried using ISFILTERED at the day number level; but having some filter context challenges

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.