March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi All
Does anyone know if PBI Desktop can generate alerts and notifications based on DAX logic, including calculated columns and measures ?
Cheers
Paul
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
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
@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?
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
Hi @Paulx99,
We are not able to configure alerts or notifications in Power BI Desktop currently. For this issue, please submit a idea in Power BI Idea forum.
Best Regards,
Qiuyun Yu
Ok thanks for letting me know. would be great if it could be done !
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
146 | |
97 | |
79 | |
69 |