Forum Discussion

collmomo's avatar
collmomo
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Date Comparison

  *** 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 comb...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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