Forum Discussion
How to make a static column for the table?
Anonymous
Please see the attachment. Hope it is helpful.
Super UserAnonymous
Do you mean that you have 4 regions? and no matter what region you choose, you want to show all country's value?
Could you please provide the expected output in details?
I have data for regions and for the country(total of regions). I want to make a dynamic region column, while the country column has to be static. With this, users can see the difference between region and country. So, the region column has to change, while the country column has to be static.
When the region not selected within the slicer, both columns have to be equal, but when selected, the region column has to show appropriate values for the selected region.
I selected the region from slicer, data in the table changed, but I want to be country column to be static.
- ryan_mayu
Anonymous
have you tried remove remoefilters
something like:
calculate([country measure],removefilters....)
https://docs.microsoft.com/en-us/dax/removefilters-function-dax
ryan_mayu What if I have column country instead of measure?
- ryan_mayu
Anonymous
if it's in the same table visual, i think you need to create a measure. If not, you can change visual interact
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions