Forum Discussion
Anonymous
6 years agoNot applicable
Calendar Slicer - Only Display Selectable Months with Data
Dear Group: I tried to post this, but the website errored out, so if it is a duplicate, please accept my apologies. Please understand, I am new to Power BI and this is my first report, so i...
- 6 years ago
Anonymous, try this:
Two fact tables:
Sales_US
Sales_Other
Create a calculated table:
SalesDates = VAR DatesUS = SELECTCOLUMNS ( Sales_US, "Date", Sales_US[Date] ) VAR DatesOther = SELECTCOLUMNS ( Sales_Other, "Date", Sales_Other[Date] ) VAR DatesAll = UNION ( DatesUS, DatesOther ) VAR DatesDistinct = DISTINCT ( DatesAll ) RETURN DatesDistinctJoin the calculated table to the date table:
Create matrix. The row field should be Date from the date table (not the calculated table).
Create slicer using the calculated table.
Anonymous
6 years agoNot applicable
Thank you SO MUCH for the help. That is exactly what I needed and would never have been able to figure that out on my own, but it is exactly what I needed. I appreciate the help and time you took with me more than you know.
DataInsights
Super User
6 years agoAwesome! Best of luck.
--Aaron