Forum Discussion
ISSUE : Format fields in the matrix visual based on the blank values.
See attached - this becomes much more complex as you cannot provide computed conditional formatting to something that isn't there,
Super UserIt is possible with the matrix visual but you need to create measures for that .
Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) and show the expected outcome.
Hi,
I try again to post my message. Yesterday it went wrong.
This is the input table
| Vendor | Line item | Period | Amount | ... |
| MSFT | L0052 | 1 | 100 | |
| MSFT | L0052 | 3 | 100 | |
| PXS | L0001 | 2 | 100 | |
| TEL | L0008 | 3 | 100 |
Expected outcome
| 1 | 2 | 3 | TOTAL | |
MSFT - L0052 | 100 100 | ☹️ ☹️ | 100 100 | 200 200 |
PXS - L0001 | ☹️ ☹️ | 100 100 | ☹️ ☹️ | 100 100 |
TEL - L0008 | ☹️ ☹️ |
| 100 100 | 100 100 |
Instead of colouring my field in RED, I have added a smiley.
Kind regards
An
- lbendlin
Here is a simplistic "solution". For a proper solution you need measures. When you say "month" do you mean "period" ?