Column chart salary and salary %

[jyaul786]

Dear Friend,

i have one table : salary_table: 

Emp ID	salary
emp1	100
emp2	2589
emp3	5412
emp4	69854
emp5	411

and i want to display column chart, with changeable salary and salary %  by slicer selection : Salary & Salary %

so that i create one extra table with field View By values( Salary and Salary %):  

i created measures: 

Salary_ =

var salary=SUM(salary_table[salary])

var salary_percentage=salary/CALCULATE(SUM(salary_table[salary]),ALL(salary_table))

return

IF(SELECTEDVALUE('Table'[ViewBy])="Salary",salary,salary_percentage)

whenever i change with slicer to Salary % , i would like to get salary % on column chart.How can i get this, or do you have another idea.

Thanks

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please try using Field Parameter feature.
Please check the below picture and the attached pbix file.

[jyaul786]

Thanks for your reply, actually i am using Power BI Desktop RS where fields parameter is not supported by RS. if you have any other solution then let me know.