Forum Discussion
Funnel Chart with filtered months
Super UserThis worked great. Thanks.
I have another problem though, since I have many other data and the actual sales data come from another table, when I try to create relations between the Data table you created and the orders table through the dates the system won't let it because one of the columns should have unique data and they don't (the Data table have 3 lines for each date and the Order table have many lines for each date, each with its own purchase).
When I try to make the relation with the columns from the other tables, it messes with the dates in other charts and the Funnel won't respond to these changes in date.
For example, the Orders table have something like:
OrderDate ProductBought Value
01/01/2018 X 10,00
01/01/2018 Y 20,00
02/01/2018 X 10,00
02/01/2018 Z 15,00
03/01/2018 X 10,00
- Ashish_Mathur
Hi,
You will have to create a Calendar Table with all unique dates. Create a elationship from the date column of both Tables to the Date column of the Calendar Table. In your Calendar Table, write calculated column formulas to extract Year and Month by using =YEAR(Calendar[Date]) and =FORMAT(Calendar[Date],"mmmm"). In which ever visual you now create, drag Year/Month fields from the Calendar Table.
Hope this helps.
