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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Stacked bar chart are empy in PBI Service

I have a simple bar chart. It was working in both PBI Desktop and PBI Service, but now it only works in Desktop. I don't know if it has something to do with the last update, but it is the only thing I can imagine. I also noticed that more people are having problems with charts that have stopped working in PBI Service.

 

As you can see in the second image, I have older versions of the same report (different pbix files) and they are having the same problem.

 

I am using only two fields for this chart: Axis = Categories and Value = Measure.

 

Category_Measure = VAR FacID = VALUES('Facility ID_Table'[Facility ID])
                         RETURN
                         CALCULATE(COUNTAX('Facility ID_Table';[0_All_Item Type_Percentage]);
                             FILTER(FacID;
                                 COUNTROWS(
                                     FILTER('Category_Dymanic';
                                         SUMX('Facility ID_Table';[0_All_Item Type_Percentage]) > 'Category_Dymanic'[Min] &&
                                         SUMX('Facility ID_Table';[0_All_Item Type_Percentage]) <= 'Category_Dymanic'[Max]))))

 

PBI Desktop (ok)PBI Desktop (ok)

 

PBI Service (omg)PBI Service (omg)

 

 

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

Hi @Vinicius777,

 

Would you please share the issued pbix file with us? You can upload it to your Onedrive and send the link to me via private message. 

 

Please try different browsers to see if the same issue occurs. Also you can click on the Refresh button on the report page to see if any data display in the chart. 

 

q1.PNG

 

Best Regards,
Qiuyun Yu 

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