Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
*** under slicer 2 in the result table should be forecast and the rows should be month rows.
Hello,
The objective is to get table where I can dynamically choose the date/process combinations.
My Steps to solve this:
My Problem:
I cannot find a way to have my calendar table slice on 2015 and 2016 for Slicer 1 & Slicer 2.
Any way to tackle this in another way ?
Solved! Go to Solution.
Hi @collmomo,
Based on my understanding, you want to display Revenues and Expenses based on filtered year and process, right?
In my opinion, you can create columns to return Year and MonthName, then create a matrix visual to display values. Use two slicers to filter year and process values. See:
Best Regards,
Qiuyun Yu
Hi @collmomo,
Based on my understanding, you want to display Revenues and Expenses based on filtered year and process, right?
In my opinion, you can create columns to return Year and MonthName, then create a matrix visual to display values. Use two slicers to filter year and process values. See:
Best Regards,
Qiuyun Yu