Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
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
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |