cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jorismo
Helper II
Helper II

Area chart - only specific values

Hi all,

 

new problem for me.

 

i've got an sql data source wich is reporting the dates and if there is an violation of a ticket.

 

Now I want to plot this on an Area chart, x-axis is the date the Y-axis must be the number of violations (so only the 1 values).

 

https://drive.google.com/open?id=120TSwVz6t5HYuECgqdJnu6101XTDU3cze_H2OQNkZ2U

 

This is an link to my data source exported to xls

 

Hope someone can give a an helping hand!

1 ACCEPTED SOLUTION

Hi @jorismo,

You just add the sum(violation) as value, and date as x-axis level. Please see the following screenshot.

1.PNG

You can download the attachment to check more details.

Best Regards,
Angelia

View solution in original post

4 REPLIES 4
v-huizhn-msft
Microsoft
Microsoft

Hi @jorismo,

Based on my understanding, you just want to display the date whose violated value is equal to 1. If my understanding is right, you can add a visual level filter to filter violated is 1, please see the following screenshot. Create a Area Chart, select the data as x-asix, violated as y-axis and add a filter(highlighted in red line).

1.PNG

Please respond to me if you have any other issue.

Best Regards,
Angelia

Hi,

 

thanks for your answer, maybe I was a bit unclear.

 

If there was an SLA violation the table gets a 1, otherwise (no violation) will get an 0.

But there could be more dan 1 violation per day (if there are 5 tickets, maybe 3 gets the violation)

 

So I want to view every day in the chart, even if there aren't any violations, if there are violations I want to see how many.

 

It possible that on day 1 only 1 violation is, day 2 5 violations, day 3 0violations, day4 3violations.

 

THanks

Hi @jorismo,

You just add the sum(violation) as value, and date as x-axis level. Please see the following screenshot.

1.PNG

You can download the attachment to check more details.

Best Regards,
Angelia

Hi,

 

YES! this solves my issue.

 

Thanks!

 

Joris

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

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.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors