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 everyone,
I have a small data set of only three months. Some variables had no data on a daily basis. To make a continuous line chart and matrix table, I've created a measure using the IF and BLANK statement (see image). However, in return, Power BI showed a table for the whole year. And adding a slicer didn't work, because the slicer showed only the three months I've actually data of. Can anyone explain what is going on?
Solved! Go to Solution.
Hi @Anonymous ,
In Power BI there is an option on the Data load that if turn on autommatically transform any date column into a calendar table (beginning on january ending on December). You need to turn this off.
Check link below on why you should turn this off.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
In Power BI there is an option on the Data load that if turn on autommatically transform any date column into a calendar table (beginning on january ending on December). You need to turn this off.
Check link below on why you should turn this off.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |