Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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