Change column name if filter is changed value in Power BI

[Analitika]

Hello,

I would like to ask how to make that if user selects filter value, then changes visual table column name. For example, filter contains price/unit selection, if user selects filter value price, then visual column name is price, if selects unit, then colum name is unit? How to achieve this in Power BI?

[isabella · Accepted solution]

Hi @Analitika 

I did a local test，hope it will help you.

Here is my test table

Then I create 2 measures

saleprice measure = SUM([salesprice])

salevolumn measure = SUM([salesvolumn])

then I create a table for choose the measure

Create a slicer

Then I create the most important measure ,use this measure you can change the value  by slicer

Measure 2 = SWITCH(TRUE(),SELECTEDVALUE('slicer for measure type'[type],"no option")="price",[saleprice measure],SELECTEDVALUE('slicer for measure type'[type],"no option")="volumn",[salevolumn measure],[saleprice measure])

When I select the price on the slicer ,this measure will show [saleprice measure]，when I select volumn， it will show [saleprice measure]，and when no one selected，I will let it show [saleprice measure]

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arul]

@Analitika ,

Please check this thread if it is solves your problem or not.

https://community.powerbi.com/t5/Desktop/Create-table-from-measure-for-visual/m-p/2501880#M889608 

Thanks,

Arul