cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SM_1997_
Frequent Visitor

Calculate SLA percentage and insert line value

Hello,

 

I am trying to divide the count of "taskslatable_has_breached" filtered by false by the count of "inc_number" and display it as a percentage that can be displayed as the line value in a line and clustered column chart. 

 

Edit: Also, is it possible to insert a measure for "line values" in a clustered column chart?

 

Edit2: I tried using this solution but it said that it couldn't display the visual when I putthe measure in for "line values"

 

I have attached a screenshot of basically what I'm looking for.

Table.jpg

Visual.png

PPT Visual.jpg

   

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @SM_1997_ ,

 

I tested on my side. And the measure can be put into Line values.

vstephenmsft_0-1638431809304.png

 

If the measure cannot be displayed, please try to change the visual to a table visual to see if the measure has values. It may be that the measure is written incorrectly.

vstephenmsft_1-1638431913142.png

 

Best Regards,

Stephen Tao

 

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

 

View solution in original post

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @SM_1997_ ,

 

I tested on my side. And the measure can be put into Line values.

vstephenmsft_0-1638431809304.png

 

If the measure cannot be displayed, please try to change the visual to a table visual to see if the measure has values. It may be that the measure is written incorrectly.

vstephenmsft_1-1638431913142.png

 

Best Regards,

Stephen Tao

 

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

 

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors