Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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.
Solved! Go to 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
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
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |