Forum Discussion

F_Reh's avatar
F_Reh
Post Patron
5 months ago
Solved

Line-by-Line conditional formatting for Heatmap (Matrix) possible ?

Good Morning,   I have a current heatmap (Matrix) like this:     Is it possible to have each line having its own conditional formatting based on a set period. In other words, colours that ...
Need Help
Show and Tell
Tips and Tricks
  • F_Reh's avatar
    F_Reh
    5 months ago

    I appreciate these solutions - Can I confirm whether either calculate the specific averages for each individual Category (X1,X2,X3) which is what I am seeking, or is it the average for the entire dataset (which is not quite what I am seeking)..

     

    Also, just to clarify the Heatmap has raw figures i.e numerics only (Not percentages).....

     

    Or could it be better to use an SPC Chart graph - rather than the present Heat map matrix ? An SPC Chart graph like this:

     

     

    And create a single-option slicer to determine which of the Categories (X1,X2,X3) is being looked at at each time (in the proposed SPC Chart graph) ?

v-tejrama's avatar
v-tejrama
Community Support
5 months ago

Hi F_Reh ,

 

Thank you danextian  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

  • v-tejrama's avatar
    v-tejrama
    Community Support
    5 months ago

    Hi F_Reh ,

     

    I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

    Thank you.