Forum Discussion
Post ProdigyTwo columns on same row on slicer visual
I have two columns (let say Table A and Table B). There is a one-to-one relationship between tables. I wanted to create a slicer filter that takes id column from Table A and a description of that id from Table B and shows both of them in one row. I tried to show in slicer filter but one of the columns goes down one level in the hierarchy as shown in the picture:
Is there any way we could create a slicer that shows both columns in the same row something like that shown in below picture:
Hi,
Yes, you can achieve this by creating a calculated table that combines the ID column from Table A and the description column from Table B. Once you have created the calculated table, you can use it as the source for your slicer filter and both columns (ID and Description) will be displayed in the same row.
3 Replies
hummingbirdHelper II
Hi,
Yes, you can achieve this by creating a calculated table that combines the ID column from Table A and the description column from Table B. Once you have created the calculated table, you can use it as the source for your slicer filter and both columns (ID and Description) will be displayed in the same row.
Dunner2020Hi hummingbird ,
Do I need to link the newly calculated table to the existing table? If I dont, then how would slicer work if I chose any value?
- hummingbird
Hi,
No, you do not need to link the calculated table to the existing tables, but it depends on your use case. The calculated table would have the data that you need to display in the slicer filter, so it will work independently without the need for a relationship with the existing tables. If you choose a value in the slicer, it will filter the data in your report based on the values in the calculated table. However, if you want the slicer to impact other visuals in your report, you will need to create a relationship between the calculated table and the other data sources in your report.