Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix undefined

Hi Team,   I used matrix visual where i amusing 3 fileds called UNITS,RATIO PERCENTAGE,ERROR DIFF automatically  taking Sum.  how to avoid auto summarization in Matrix and I want to show zero in bl...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    According to your description,I think replace blank value to zreo in PQ first.You can disable total in matrix format.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MFelix's avatar
MFelix
Super User
5 years ago

Hi Anonymous ,

 

The auto summarization is defined at the column level you need to select the column you need and set the summarization to Don't summarize, this however will be applied to all visualizations.

 

 

Just for a particular visualization you need to go column by column and set the summarization to Don't summarize on the options of each column:

 

Regarding the second part of your question to avoid blanks you need to have a measure to have that 0 inforced.

 

For that you need to have add a +0 or a IF statement. Don't know how your data is set but you can do a SUM, AVERAGE, MAX or MIN to return the values and then add a +0.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi 

    Please can you tell me how to disable  don't summarization for matrix visual.

    • MFelix's avatar
      MFelix
      Super User
      5 years ago

      Hi Anonymous ,

       

      You need to go to the matrix option and for each column that you place on the matrix and select the option don't summarize: