cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Automation of specific visuals from an indicator

Hi all, I am quite new to Power BI so am trying to get a sense of what is in scope/feasible.  I am trying to complete the following task: Take some metric data which is either stored in a DB or on Sharepoint and compare the values against a certain threshold. If they don't meet the criteria, a specific visualization will be triggered and put on the report showing the off-track metric, as well as a summary (again only triggered by the exception noted in comparing values). I know this can be done fairly easily manually, but my question is whether this could be fully automated? If so, a push in the right direction would be most appreciated.

 

Thanks much! 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Automation of specific visuals from an indicator

Hi @Anonymous,

 

We can use if function to work on it. I made one sample for your reference. If it doesn't meet your requirement, kindly share your sample data and excepted result to me.

 

1. To create the measures as below.

 

total = SUM(Table1[value])
fil = IF([total]>15,[total],BLANK())
fil2 = IF([total]>18,[total]," ")

2. Then we can get the result as below.

Capture.PNG

 

For more details, please check the pbix as attached.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Automation of specific visuals from an indicator

Hi @Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 337 members 3,444 guests
Please welcome our newest community members: