Forum Discussion

Powerbi12399's avatar
Powerbi12399
Regular Visitor
10 months ago
Solved

Age Gender Population Pyramid keeps crashing

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...
Need Help
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    10 months ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 months ago

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.