Forum Discussion

Paulx99's avatar
Paulx99
Icon for Kudo Kingpin rankKudo Kingpin
10 years ago

PBI Desktop Alerts and Notifications

Hi All

 

Does anyone know if PBI Desktop can generate alerts and notifications based on DAX logic, including calculated columns and measures ?

 

Cheers

 

Paul

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Paulx99 Can you describe this a bit more?.. Alerts and notifications on a device, like outside the desktop file. Or are you talking about visually highlighting certain elements in a visual conditionally?

    • Paulx99's avatar
      Paulx99
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago

      Hi Eno1978

       

      Thanks for your reply and sorry for the lateness of mine. What I'm trying to do is to visually highlight exceptions that result from conditional statements. A simple example - I calculate profit:

      profit = [sale price] - [cost price]

       

      Then, I create a conditional statement to identify a profit, loss or break even situation:

      profit desc = IF([profit]>0, "profit", IF([profit]<0,"loss", IF([profit]=0,"break even")))

       

      What I want to be able to do is visually highlight (create an automatic highlighted alert for, in the data view), profit desc if 

      profit desc = loss

       

      Something like ALERT if profit_desc = "loss"

       

      would be great !

       

      Paul

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi Paul,

     

    Based on my understanding, when you type the DAX in Power BI Desktop, if there is something wrong within the DAX, you want to get some notification or alerts about this error, right?

     

    In Power BI desktop, the DAX editor includes suggestions, a feature used to create syntactically correct formulas by helping us select the correct elements. Generally, if there is something wrong in DAX, the error will display like below:

     

    Reference:

    DAX basics in Power BI Desktop

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • Paulx99's avatar
      Paulx99
      Icon for Kudo Kingpin rankKudo Kingpin
      10 years ago

      Hi Qiuyun

       

      Sorry for the late reply. Thanks for your reply, but unfortunately, what you've mentioned below is not what I am talking about. What I want to be able to do is to visually highlight exceptions that result from conditional statements. Please refer to my reply to eno1978.

       

      Regards

       

       

      Paul