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 a table in my Power BI to show selected data from the past 7 days. However, if there are empty columns in the data set (not the date or order number) then it doesn't show up at all.
Any thoughts?
Solved! Go to Solution.
Hi @Anonymous ,
Did you create a date table that has consecutive dates and contains all the dates in the fact table? Create relationship between date table and fact table. Then use date column in date table and select 'show item with no data' for it.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@Anonymous ,
It does not have date the difficult to show. If you join with date table it will show a blank date
or
Use +0 on a measure or use this option if you joining the tables
@amitchandak @Pragati11 Annoying just ticking 'show items with no data' doesn't solve the issue.
The data will always have a date it is column such as part number or component type that could be blank.
Hi @Anonymous ,
Did you create a date table that has consecutive dates and contains all the dates in the fact table? Create relationship between date table and fact table. Then use date column in date table and select 'show item with no data' for it.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
This is not enough for answering your query.
Share some screesnhots around sample data, visuals and the output expected.
Thanks,
Pragati
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |