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 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?

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

5 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    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

  • Praful_Potphode's avatar
    Praful_Potphode
    Super User
    10 months ago

    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

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 months ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 months ago

    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 .