Forum Discussion
Hide a column in table
Hi
In my dashboard , i need to show measures in below format
Example:
In a slicer i have the following measures Net sales2023, Net sales2022, Net Sales%, Gross Sales2023 ,Gross Sales 2022..etc , When i Select the Measure "Net sales2023" it should Dispaly Net sales2023 ,Net sales2022 and Net sales%. (On selecting one mesaure it should display all the 3 measures of Net Sales in the table)
And
When i Unselect the measure Net sales2023 from the slicer the 3 Measures should not been shown in the table .(the coloumns should be hide)
By Using SELECTEDVALUE Function i can select measures in required format , my problem is i cannot hide the coloum when i unselect the measure .
Regards
Manju
1 Reply
- MFelixSuper User
Hi Anonymous ,
How are you creating the values for the slicer and showing the values in the matrix, is it a disconnected table? Field parameters?
If you have the measures all created the best option is to use the field parameters:
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters