Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
So I am tryin to display the date as "mmm" ("Ene", "Feb", "Mar", etc.) and made a column with DAX:
But the timeline will hide the months that are not selected, despite the "Show elements with no data" is selected, not like if I just use Date Hierarchy with month and data will appear or not but the month column is always shown:
This is the result I am having, with fomated column and timeline hidding other months:
This is the result I want with data shown by month, but all months are always visible
I am currently using Timeline 2.4.0
Solved! Go to Solution.
@AlejoCumpa , Show Item with no data will work only when you use date from another table say date table. The same is true with +0 in the measure.
If you are not using a date table use that and try
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@AlejoCumpa , Show Item with no data will work only when you use date from another table say date table. The same is true with +0 in the measure.
If you are not using a date table use that and try
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |