Forum Discussion

Dan849800's avatar
Dan849800
Frequent Visitor
9 years ago
Solved

Dynamic Filters and Graph creation

I have six columns in table and want to create two slicers based on dails and hours, if user select Dials, 'dail information' should show on wheel/ vice versa, It means if user select dails(Slicer1) ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Dan849800,

    >>I want to repeat Required dails column with all fields.

    You can use CONCATENATE function to create calculated columns. Then you can use the new columns to create slicers or visuals.

    Required Dails Schedule dails = CONCATENATE(Table[Required Dails],Table[Schedule dails])

    Required Forecasted dails = CONCATENATE(Table[Required Dails],Table[Forecasted dails])

    Required dails Actaul dails = CONCATENATE(Table[Required Dails],Table[Actaul dails])

     


    If this not what you want, please post your sample data and list expected result for further analysis.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Dan849800,

>>I want to repeat Required dails column with all fields.

You can use CONCATENATE function to create calculated columns. Then you can use the new columns to create slicers or visuals.

Required Dails Schedule dails = CONCATENATE(Table[Required Dails],Table[Schedule dails])

Required Forecasted dails = CONCATENATE(Table[Required Dails],Table[Forecasted dails])

Required dails Actaul dails = CONCATENATE(Table[Required Dails],Table[Actaul dails])

 


If this not what you want, please post your sample data and list expected result for further analysis.

Best Regards,
Angelia

  • Dan849800's avatar
    Dan849800
    Frequent Visitor
    9 years ago

    Thanks!