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 to add these kpi with these messages in power bi and if possible how to show different for different kpi. The sales value should be displayed for each sales I'd. Thanks
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"
)

3 Replies

    • 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"
)