Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have problem with stacked area chart. When measure return blank values when there is no values on plot:
My measure:
%_Time_avg_per_case_in_hours =
%_Time_avg_per_case_in_hours =
%_Time_avg_per_case_in_hours =
Solved! Go to Solution.
The solution is below:
hi @Anonymous
You need to create a dim date table and then create a relationship with tasks table by date column and use date column from dim date table for the x-axis value, then it should be ok.
If not your case, please share your sample pbix file for us have a test, that will be a great help.
Regards,
Lin
Hi @v-lili6-msft,
Thanks for answer. I already created date table:
I added "+0" and the measure is calculated properly but it still need to be changed because on chart we see dates (start of the week) where we do not have any tasks (in time record table - it is fact table):
Tasks occures in third quarter:
Chart:
hi @Anonymous
If possible, could you share us a simple sample pbix file for us have a test?
Regards,
Lin
The solution is below:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |