Forum Discussion
Help: Conditional Formatting can't work if remove [year] for a Matrix visual
Hi Anonymous
I just replicated your data, your issue is cozed when you remove the rows of matrix that leave only values in matrix, which make it not complete.
I'd suggest you move the column cntd_dif_ti_CF to Rows field:
I can't use Onedrive/dropbox…
I simplify the example/problem as follows
1) Have the dataset like
2) Create 3 matrixes for investigation
- The right top matrix has [year] in Rows.
- The right bottom matrix doesn't have [year] in Rows.
- Both the right top/bottom matrixes have conditional formatting on [cntd_ti_indicator] using [cntd_ind_color] for 'Font color' (formatted by 'Field value').
3) Click a [year] value on the left matrix; no color change for the right bottom matrix, e.g. clicking 2015...
Question:
I need a single row like the right bottom matrix and also need the color of indicators (arrows) to change according to [cntd_dif_ti_CF] (i.e. if the value of [cntd_dif_ti_CF] is positive, then green; if it's negative, then red). How should I do? Is this a bug for Power BI?
Community SupportHi Anonymous
I just replicated your data, your issue is cozed when you remove the rows of matrix that leave only values in matrix, which make it not complete.
I'd suggest you move the column cntd_dif_ti_CF to Rows field:
Thank you!
Is that possible when I click 'Total' on the left side Matrix, the new Matrix can only show 1 single row (as follows)?
- v-diye-msft
Hi Anonymous
It's not able to achieve this coz the Total was generated by the Matrix visual itself, not the actual row/column.
Would you mind marking the above post as a solution that helps others find it more quickly? thanks a lot!
OK, thanks.