Forum Discussion
Dynamic column section based on filter
Hi Dan849800,
For your requriement, you want create two slicer, one slicer including Dail1, Dail2, Dail3 values, and another slicer including Hour1, Hour2, Hour3 values, right? If it is, I try to reproduce your scenario as follows.
Right click Edit Query, select Dail1, Dail2, Dail3 columns->click Unpivot columns under Tranform on how page. Then select another Hour1, Hour2, Hour3 columns->click Unpivot columns, click Close and Apply, you will get the following table.Create two slicers including Dail column and Hours separatly. And create table visul to display the results.
For another thing, I personally suggest you create one slicer.
1. You'd better select all the columns->Unpivot columns, you will get table.2. Create a slicer including Attribute column, you will get corresponding value when you select any value in the slicer.
If you have other issues, don't hesitate to let me know.Best Regards,
Angelia
Hi Dan849800,
For your requriement, you want create two slicer, one slicer including Dail1, Dail2, Dail3 values, and another slicer including Hour1, Hour2, Hour3 values, right? If it is, I try to reproduce your scenario as follows.
Right click Edit Query, select Dail1, Dail2, Dail3 columns->click Unpivot columns under Tranform on how page. Then select another Hour1, Hour2, Hour3 columns->click Unpivot columns, click Close and Apply, you will get the following table.
Create two slicers including Dail column and Hours separatly. And create table visul to display the results.
For another thing, I personally suggest you create one slicer.
1. You'd better select all the columns->Unpivot columns, you will get table.
2. Create a slicer including Attribute column, you will get corresponding value when you select any value in the slicer.
If you have other issues, don't hesitate to let me know.
Best Regards,
Angelia
Hi Angelia,
Awesome, genies.it works! , I only required two fileds in slicers (Dails/Hours), I have created calculated colum for this.
I have few more questions, if possible please share email id. Thank you again!