Age Gender Population Pyramid keeps crashing

[Powerbi12399]

Hello All, i have the following measures:

• Age bin
• Male HC = CALCULATE(COUNTROWS(Sheet1), Sheet1[Gender for Insurance Coverage] = "Male")
• Female HC =CALCULATE(COUNTROWS(Sheet1),Sheet1[Gender for Insurance Coverage] = "Female")

And every time I put the male HC and female HC into the stacked bar chart or the population pyramid visual that I downloaded from PBI visuals, there will be an Error fetching data for the visual (an unexpected exception occurred).

these measures are all under one data table could someone help me with this pls?

[v-tsaipranay]

Hi @Powerbi12399 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you .

[v-tsaipranay]

Hi @Powerbi12399 ,

I wanted to check if you had the opportunity to review the information provided. If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @Powerbi12399 ,

Thanks for reaching out to the Microsoft fabric community forum. 

Based on your scenario, the issue might be related to the data type, your measures, or the custom Population Pyramid visual. Please check that the Gender column for Insurance Coverage is set to Text and doesn't contain blanks or unexpected values, as these can cause issues with visuals.

Your measures appear correct, but make sure the filter in CALCULATE matches the text in your column exactly. Try using the same measures in a standard Stacked Bar Chart to see if the problem persists; if it works, the issue may be with the custom visual. You could also recreate the measures and visual in a new PBIX file to rule out caching or model-specific problems.

If the error continues, sharing a sample PBIX file as menationed by @PhilipTreacy and @Praful_Potphode  with similar structure (with sensitive data masked) may help with further troubleshooting. This process should help determine whether the problem lies with the data, the measures, or the visual itself.

Thank you.

[Praful_Potphode]

Hi @Powerbi12399 ,

Please share the sample pbix file for reference.

From what it looks like, it could be measure issue.check the data type of column used in measure.

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[PhilipTreacy · Accepted solution]

Hi @Powerbi12399 

I can't see why you'd be getting that error form somethign so straight forward.  Can you supply your PBIX file so I can check it?

Have you tried creating a new file?

Regards

Phil