Forum Discussion
Power BI issue on Matrix Visual
Hi, I have some trouble with the Matrix Visual in PowerBI, hope that somebody could help me out: I need to show the sum for my invoices, therefore I created my rows in hierarchical order (like C...
Hi Anonymous
In this case you don't need SELECTEDVALUE because the matrix supplies the filter context.
Create a measure:
SelectedStatus = IF( 'Table'[amount]> 0, "positive", "negative")
and put that on the Matrix.
You may need to set a visual level filter "show items when the value is not blank" if you're getting blank items.
You also may need to consider what you want if the 'Table'[amount] = 0. At the moment with my code, following your example it will show "negative" for Zero entries. You may want a measure like this...
SelectedStatus = IF( 'Table'[amount]> 0, "positive", IF( 'Table'[amount]= 0, "zero", "negative"))
to show zero separately.
Hope this helps
Stuart