Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |