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.
The data does not have all the dates, I want to see blanks where there is no corresponding record. In the below diagram i have given monthly filter and its only showing the data for first 9 days as avaialble how can i show the rest of the dates will no data .
Solved! Go to Solution.
Create a seperate dates table using dax
Link this to the sales data and then change the settings on the table : visualizations/values to "show items wth no data"
Create a seperate dates table using dax
Link this to the sales data and then change the settings on the table : visualizations/values to "show items wth no data"
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 |
---|---|
47 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |