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.
Hi,
I created a dashboard like this and "Show items with no data" is applied to the bar chart and the summary metrics.
In the first screen shot, I was able to review all months - eg. 2016-04, 2016-05, 2016-06, 2016-07, 2016-08, and etc.
As applying PART filter like the 2nd screen shot, 2016-06 and 2016-10 were missing. I realize that both months have sum of zero and the event that I have is something like EVENT = SUM(table[freq]) + 0.
Could anyone tell me how I can make those months w/ zero events e.g. 2016-06 & 2016-10 display on the x-asix?
Thank you in advance!
Solved! Go to Solution.
hi,@lindseyhuang
After my research, you can do these follow my steps as below:
Step1:
use Values function to create a table
Table 2 = VALUES('Table'[Year month])
Step2:
Create the relationship between Table 2 and Table
Step3:
Drag field Year month from Table 2 into Axis and set Show items with no data
Result:
here is pbix, please try it
https://www.dropbox.com/s/pb4ej8umprl8ma5/Show%20items%20with%20no%20data.pbix?dl=0
Best Regards,
Lin
hi,@lindseyhuang
After my research, you can do these follow my steps as below:
Step1:
use Values function to create a table
Table 2 = VALUES('Table'[Year month])
Step2:
Create the relationship between Table 2 and Table
Step3:
Drag field Year month from Table 2 into Axis and set Show items with no data
Result:
here is pbix, please try it
https://www.dropbox.com/s/pb4ej8umprl8ma5/Show%20items%20with%20no%20data.pbix?dl=0
Best Regards,
Lin
Thanks for the response. I love it.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |