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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Line and Clustered Column Chart > Show As Table > Measures Display Incorrect Value

We are seeing an issue in the 'Show As Table' view for a Line and Clustered Column Chart when rendering measures that are calculated as a percentage.

The percentages shown in the table are incorrect, looks as though it converting the Accept and Reject counts into a percentage instead.

fdb-lee_0-1623313889103.png

 

The DAX to create the rate measures are as follows:

Acceptance Rate = DIVIDE(SUM(Table1[Accepted Count]), SUM(Table1[Action Count]),0)
Offer Rate = DIVIDE(SUM(Table1[Hit Count]), Sum(Table2[ConsultationCount]), 0)

The chart is constructed like so:

fdb-lee_1-1623314058015.png
All instances of the rate measures are displayed correctly elsewhere throughout the report

fdb-lee_2-1623314228922.png
fdb-lee_3-1623314359311.png

 

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

I tried the latest version to create a report and it seems to be working fine.

Anonymous
Not applicable

We found a solution, odd but effective.

 

  1. Open in Desktop (or Service)
  2. Change the chart type
  3. Move the rate line values into tooltips
  4. Change the chart type back
  5. Move the rate tooltips back into line values
  6. Republish