Dynamic Filters and Graph creation

[Dan849800]

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) first 3 columns in pic should display on wheel

                                               if user select Hours(Slicer2) last 3 columns in pic should display on wheel.

For this i have got solution from below link,

http://community.powerbi.com/t5/Desktop/Dynamic-column-section-based-on-filter/m-p/134336/highlight/...

Continue to above solution , What i need is I have four fields Schedule_Dails,Forecasted_Dails,Required_Dails,Actual dails

I want to repeat Required dails column with all fields , Like

Required Dails Schedule dails  --Required Forecasted dails- Required dails Actaul dails ( In a graph want to repeat required dails 3 times with all other fileds), Hope this help.any questions let me know

Thanks,

Dan.

[v-huizhn-msft · Accepted solution]

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]

Thanks!