Forum Discussion
ISSUE : Format fields in the matrix visual based on the blank values.
ISSUE : Format fields in the matrix visual based on the blank values.
I want to format the fields of matrix visual to RED when, the current month's value is BLANK and previous month's value is NON-BLANK. Is that possible with the visual matrix ? Or is there another visual that can do this ?
See attached - this becomes much more complex as you cannot provide computed conditional formatting to something that isn't there,
8 Replies
- lbendlin
Super User
It 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" ?
Hi,
This is the input table :
Vendor Period Actual 2020 Comment MSFT 1 100 XXXX MSFT 2 200 XXXX MSFT 4 300 XXXX PXS 2 100 XXXX PXS 4 100 XXXX TEL 3 100 XXXX Expected outcome :
1 2 3 4 TOTAL MSFT 100 200 -
300 600 PXS - 100 - 100 200 TEL 100 - 100 I can't added a pbx.file to this message. I hope this clarifies my question.
Thanks for your help
An
