In Power BI Report Builder Diagram missing values

[andiart]

Hi ,

I wanted to make a 3D diagram with the report builder, to showcase the number of it tickets by year and by departemend issued.

Now I got something, but instead of the department names I see "Department A" "Department B"... Though the number of departements is right. The same for the year (I look at 2023 and 2024). The sound Year A and Year B.

A Screenshot:

The number of the tickets has variance but it does not correspond to the numbers in my power bi report. Here the maximum is at about 80 while in the bi report it is nearly a thousand.

Can you lead me to the point, which I missed?

[Anonymous]

Hi @andiart ,

It sounds like there are a couple of key areas we need to address to resolve the discrepancies you're experiencing: the labeling of departments and years, and the variance in ticket numbers between your diagram and the Power BI report.

Addressing Labeling of Departments and Years

The issue with departments and years being labeled as "Department A", "Department B", "Year A", and "Year B" instead of their actual names or values likely stems from the way the data is being interpreted or displayed in the diagram. This can happen if the diagram is not correctly linked to the data source fields or if there's a formatting issue.

1. Verify Data Source Connections: Ensure that your diagram is correctly connected to the appropriate fields in your data source. In Power BI Report Builder, you can do this by checking the data source settings and ensuring that the fields for departments and years are correctly mapped.
2. Check Field Formatting: Sometimes, fields may be formatted in a way that doesn't display their actual values. Double-check the formatting settings for your department and year fields within the report builder to ensure they're set to display text or numbers as applicable.

Addressing Variance in Ticket Numbers

The discrepancy in ticket numbers between your diagram and the Power BI report could be due to several factors, including data filtering, aggregation settings, or issues with data refresh.

1. Review Data Aggregation and Filtering: Ensure that the same aggregation (e.g., sum, average) is applied to the ticket numbers in both your diagram and the Power BI report. Also, verify that any filters applied in one view are consistently applied in the other to ensure you're comparing like for like.
2. Data Refresh: If your Power BI report is connected to a live data source, make sure that the data in your Report Builder diagram is up to date. You may need to refresh the data in your Report Builder project to match the latest data in your Power BI report.

For more detailed guidance on working with 3D diagrams in Power BI Report Builder, including adding 3D effects and ensuring accurate data representation, you might find the following documentation helpful: Add 3D effects to a Power BI paginated report chart - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andiart]

May it be a problem, that I don't have a report server license and though it doesn't show me correct values?

[Anonymous · Accepted solution]

Hi @andiart 

EVALUATE is a DAX statement that is needed to execute a query. EVALUATE followed by any table expression returns the result of the table expression. Moreover, one or more EVALUATE statements can be preceded by special definitions like local tables, columns, measures, and variables that have the scope of the entire batch of EVALUATE statements executed together.

SUMMARIZECOLUMNS: Returns a summary table over a set of groups.

Whether or not you have a PBIRS license does not affect the value, some features require a license to be used.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[andiart]

Hi Thanks for the nice answer. In my data set settings I have the following query:

EVALUATE SUMMARIZECOLUMNS('Datum'[Jahr], 'Datum'[Quarter], 'Datum'[Monat], 'Datum'[Date], 'ManageEngine Report Framework (2)'[Anfrage-ID], 'ManageEngine Report Framework (2)'[Standort Clean])

What does the commands evaluate and summarizecolumns mean? maybe I need to rewrite it?

In the query designer I have the following: