Forum Discussion
Finding Intersection between two columns
- Anonymous2 years ago
Hi, Sathvikakurli
You can use slicers and table visuals to select a month and display the employees for that month. Based on your data:
You need to create a slicer and put the month in BaseLine month into the field of the slicer (if Month is not found in your BaseLine month, you need to open the Date hierarchy as shown below):
Place EmpID's, Baseline month in the columns of table visual:
Click on a month through the slicer, and the table visual will display the EmpID's of the corresponding month.
You can also define more advanced filtering capabilities in the Filters sidebar. If the above tips help you, that's great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Sathvikakurli
You can use slicers and table visuals to select a month and display the employees for that month. Based on your data:
You need to create a slicer and put the month in BaseLine month into the field of the slicer (if Month is not found in your BaseLine month, you need to open the Date hierarchy as shown below):
Place EmpID's, Baseline month in the columns of table visual:
Click on a month through the slicer, and the table visual will display the EmpID's of the corresponding month.
You can also define more advanced filtering capabilities in the Filters sidebar. If the above tips help you, that's great.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.