Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Chart in Dashboard showing records as blank - although default value is no

(0) ShareShare
ReportReport
Posted on by

Hi,


I have a two option field in my entity called Paid or Unpaid - default value set to No.

I have created a simple chart using the Paid or Unpaid for the Legend Entries(series) Count: all

For the Horizontal (Category) Axis label I've also selected the Paid or Unpaid two option field.

 

The chart uses a view that filters out records based on the current Year field and if another Approval Status field is set to 'Fully Received' 

 

This view is working as it shows two records that the Approval Status is set to 'Fully Received' and current year is 2020

 

When adding the chart to a dashboard - none interactive' - created not at entity level, the view and chart in 'preview mode' shows correctly: a bar chart with a height of two and underneath the bar a value of  'No' is displayed above the chart's Horizontal axis of Paid or Unpaid.

 

However, when the dashboard is published then added to site map of my app and the app is saved and published the dashboard shows, but the chart has (blank) displaying instead of No.

When drilling down to the records it shows the two correct records with a correct Paid or Unpaid value marked as 'No'

 

So not really sure why the chart is showing (blank) instead of 'No' 

 

Does anyone know why this is happening?

 

  

  • Community Power Platform Member Profile Picture
    on at
    Re: Chart in Dashboard showing records as blank - although default value is no

    MSO are now taking a look at his. You can follow the thread here:

     

    https://powerusers.microsoft.com/t5/Building-Power-Apps/Bug-In-chart-on-dashboard-using-Two-Option-Field/m-p/456821#M136441

     

  • Community Power Platform Member Profile Picture
    on at
    Re: Chart in Dashboard showing records as blank - although default value is no

    Thanks HShield,

     

    will do on both fronts.

     

    I'll post back here if I get any updates from MSO.

     

  • H Sheild Profile Picture
    3,000 Most Valuable Professional on at
    Re: Chart in Dashboard showing records as blank - although default value is no

    Hi @Anonymous 

     

    I think you have found a bug.  I am able to recreate your issue too.  Best to raise this one with Microsoft support.

     

    In the meantime, you could also try recreating the Paid / Unpaid field as an Optionset field (instead of Two Options) with values Paid and Unpaid.  Then create your charts off the Optionset field.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics