web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Bug - In chart on dash...
Power Apps
Unanswered

Bug - In chart on dashboard using Two Option Field

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

To MSO / MVP's

 

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'  Shows OK in dashboard design mode/preview but no correctly at run-time.

 

Another user has managed to reproduce the issue. Appears this a bug when using two option field and using the values in a chart on a dashboard.

Categories:
I have the same question (0)
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    @Anonymous 

    Could you share some screenshots and test steps?

    I am trying to reproduce your issue, so that we can provide further assistance.

    Sik

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi V-siky-msft.

     

    Steps as follows:

    1: create a field called Paid or Unpaid (two option) type and set default as 'No'

    1: create an option set called Approval Status with options as Pending, Approved. Rejected, Not submitted. Default value: Not Submitted

    2:   Create another field, (option set) called Budget Year, have options such as 2018, 2019, 2020 etc... default value 2020

    3:  Create another field (option set) called PO items received, options are Not Received, Fully Received - default value 'Not Received'.

    4: Create a view for the entity called 'Current Year Approved - Items Marked as received.

    5: Add following filters to the view:

     

    a: Approval Status is Approved.

    b: PO items Received is Fully Received

    c: Budget Year is 2020

    d: Status is Active (this is the out of the box status field)

     

    6: Create an Model Driven app from the entity then create some records, set year to 2020, Approval Status to Approved, and PO items received as 'Fully received' so they show up in the view.

    7: Go into advanced settings /customizations /customize the system and create a chart under your entity as below, with the same settings, as shown in screen-shot below of this post - choosing Paid or Unpaid as Legend entry and as Axis Horizontal category, As you can see it shows 'No' correctly as I have records meeting the filter view criteria and have paid and unpaid as a default value of 'No'

    8: Now create a Non interactive dashboard (not under the entity, but at system level). Add the chart to the dashboard, choosing the entity, View: Current year approved - items marked as received and then the chart, which I called 'All Paid and Unpaid PO's marked for Payment

    9: Publish the dashboard, then click back on the entity and publish all customizations for the entity.

    10 :Add dashboard to the app within site map etc and publish.

    12: View your dashboard within app and for me, chart on dashboard now shows (blank) instead of No for the chart.

     

    Creating the chart:

    chart.jpg

    dashboardDesignMode.jpg

    dashboardInApplication.jpg

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi, did you manage to reproduce the error?

     

  • nerdifand Profile Picture
    on at

    hello,

     

    i found this thread after searching for a problem with my charts.

    i have several charts refering to a boolean field on a 100% stacked column chart (count: non-empty)

    the charts work fine in the designer (preview mode), however they only show 100% blank in the application.

    after seeing this thread, i am reliefed, because now we can somehow assume this is a bug, inserted after an update. my charts where working fine at the end of last year.

    best regards

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard