Forum Discussion
Solved
Show Items with No Data injecting Dates
Hi all, Thanks in advance for any help. I'm trying to show sales data by date in a stacked bar chart and I would like to be able to filter by specific customers, so far no problem. I would like to...
Hi captrut
In my opinion, the problem has to do with using the "Automatic Time Intelligence" instead of a date table.
I used a simple DAX date table and everything seems to work fine.Unrelated: You might want to append the yearly tables and unpivot. I included a table called Unpivot that you might want to take a look at.
Let me know what you think.
grantsamborn
Solution Sage
Solution SageHi captrut
I'm not sure if this helps but I often add a column to my date table like this:
_InPeriod =
IF(
[Date] >= MIN( 'SalesData'[Date] )
&& [Date] <= MAX( 'SalesData'[Date] ),
TRUE(),
FALSE()
)
Then you can filter your visual with this column.