Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Value getting plotted incorrectly in built-in line chart

This randomly happens. To better illustrate, this is the bug that is occuring. The green line is the 100% line. The data point outside of the 100% grid is GC.

 

All of those points are 100% (percentage format). The visual uses a calculated measure to display data based on a selected filter. In the screenshot above, the "Billable Mandays" value is selected in the filter which should display the value of the ~Billable Utilization measure.

 

!Utilization = 
    SWITCH(
        HASONEVALUE('Utilization Switch'[Switch]),
        MIN('Utilization Switch'[Switch]) = "Billable Utilization", [~Billable Utilization],
        MIN('Utilization Switch'[Switch]) = "Non-billable Utilization", [~Non-billable Utilization],
        [~Billable Utilization]
    )

The value is computed by a measure like so:

 

~Billable Utilization = 
    CALCULATE(
        DIVIDE(SUM([Billable Mandays]), SUM([Available Workdays]))
    )

 

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @olimilo ,

 

Does the issue happen in Power BI desktop or service? Does only this line chart visual have the issue? 

 

IS it possible for you to share the pbix file with us. If it is, please upload it to your OneDrive and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info