Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello.
I have a PBI Visiual Line stacked bar chart. I have two measurements, one of sales from the current year and one from the previous year.
When I select the bar related to the current year, all of my other visuals (charts and graphs that show results by category) change to show data related to the visual. When I select the previous year's sales, all of my images are blank.
Solved! Go to Solution.
Hi @Syndicate_Admin ,
You can check the following:
1. Probably related to the fact that you use the Now() function in your formula, the time display in the Power BI service is different from the time display in the Power BI desktop.
The time in Power BI Desktop is determined by the system time set in your local computer.
The time in Power BI Service is based on the time zone of the place where your data exists.
2. Also related to date formats, such as dd/mm/yyyy or mm/dd/yyyyy, you can use the FORMAT function in DAX expressions to solve this problem.
Solved: Power BI Service - Data Missing after refresh - Microsoft Fabric Community
3. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
4. You can check to see if any filters are affecting the appearance of the data, and if you click the reset button to revert back to the default state.
If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
You can check the following:
1. Probably related to the fact that you use the Now() function in your formula, the time display in the Power BI service is different from the time display in the Power BI desktop.
The time in Power BI Desktop is determined by the system time set in your local computer.
The time in Power BI Service is based on the time zone of the place where your data exists.
2. Also related to date formats, such as dd/mm/yyyy or mm/dd/yyyyy, you can use the FORMAT function in DAX expressions to solve this problem.
Solved: Power BI Service - Data Missing after refresh - Microsoft Fabric Community
3. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it,
After a scheduled refresh the report has no data - Page 2 - Microsoft Power BI Community
4. You can check to see if any filters are affecting the appearance of the data, and if you click the reset button to revert back to the default state.
If the results don't meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do your visuals contain data related to previous year measurement?
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |