Forum Discussion

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
7 years ago
Solved

Indicator in power bi table

Hi I am using live connection and connected to ssas tabular model. I have sales data and if sales is 1000 it should display "bad" if sales 2000 it should display " ok" if 3000 then display "great" how...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    7 years ago

    NISH72 just create measure for message and then you can use it table visual or card visual

     

    Total Sales = SUM( Tables[Sales] )

Sales Message = 
SWITCH( TRUE(),
 [Total Sales] > 3000, "Great",
[Total Sales] > 2000, "Ok",
"Bad"
)
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

NISH72 New Icon set feature which came out on July 2019 can be used for this.

 

 

NISH72's avatar
NISH72
Icon for Helper IV rankHelper IV
7 years ago
But how to show different messages for different values for each sales I'd thanks
  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    NISH72 just create measure for message and then you can use it table visual or card visual

     

    Total Sales = SUM( Tables[Sales] )

Sales Message = 
SWITCH( TRUE(),
 [Total Sales] > 3000, "Great",
[Total Sales] > 2000, "Ok",
"Bad"
)