Forum Discussion
In Power BI Report Builder Diagram missing values
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.
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.
- 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.
- 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.
- 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.
- 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.
May it be a problem, that I don't have a report server license and though it doesn't show me correct values?
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.