Forum Discussion
Funnel Chart with filtered months
Super User
This 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.
Hi, I tried the solution, but i don't think it worked.
I am inserting my dashboard here .
Basically I can't seem to interact the funnel with all the other views and the slicer.
Thanks
- Ashish_Mathur
Hi,
In this PBI file, when you change the month in the slicer, all charts will respond. However, when you click on a slice of any Donut chart, the funnel chart will not response because there is no common/connecting column between the Analytics Funnel (2) table and the Plan1 (2) Table.