cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lavallee
New Member

Auto creating charts based on thresholds of a cell in a table

Wondering if its possible... I have a table.  Its source is refreshed daily. Some of cells track things like dollar amounts or percentages. I want to find out if 1) can I set a threshold for that cell such that when that threshold is crossed, the cell changes color from green to red. For example, in one row I have a cell that show a percentage of sales. I would like to set a percentage of 60%. If the table is updated and the new sales figures are updated and that particular cell sale's figure drops down to 40%. Is it possible to set an action or a trigger or anything that would then automatically change the cell color from green to red and then 2) is it possible that when that sales amount drops to that 40% that a chart would be created on another page, like a Summary Page, that shows that drop? I am imagining a Summary page that keeps track of the table data but with various chart types. Perhaps this one is a line chart and it shows up on the Summary Page because that cell in the table page (which is obviously a separate page/screen) dropped below the pre-defined threshold of 60%....does all this make sense? Is this at all possible? Any help would be greatly appreciated. 

3 REPLIES 3
v-xiaotang
Community Support
Community Support

Hi @Lavallee 

A few additional points:

(1) Here is a similar question about conditional format, please check my answer in this post, link

(2) Although the chart cannot be created automatically, you can set data alerts as a workaround, see bellow

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-alerts

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Lavallee
New Member

I will check those links out. Thank you! 

elofstrom
Resolver II
Resolver II

Lavallee - 

The built-in conditional formatting capabilities in Power BI should solve #1: Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

For #2 there isn't any "auto-create-a-chart" feature but you might be able to leverage report-page tooltips or drillthrough filters to accomplish what you want.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors