Visual and measure depending on parameter

[Analitika]

How to create Visual which will depends on Parameter setted in Query editor?

1. For example if Parameter setted to 1 Visual x axis column must be Table1[Name] but if Parameter setted to 2 Visual x axis column must be Table2[Val]
2. Parameter setted to 1, measure must be 

Measure = CALCULATE (sum(Table1[Pre_ska_1]))​

but if Parameter setted to 2, measure must be

Measure = CALCULATE (sum(Table2[Pre_ska_2]))

PBI has something like INDIRECT() excel function? So i can In table dinamically change names which in measure interpreted like columns names

Measure = CALCULATE (sum(INDIRECT(Table1[DinamicName])))​

So if Table1[DinamicName] = "Table2[Pre_ska_2]"
measure
Measure = CALCULATE (sum(INDIRECT(Table1[DinamicName])))​ sum Table2[Pre_ska_2] values

[nandukrishnavs · Accepted solution]

@Analitika 

You could try to below steps.

1. Create a Parameter
2. Create a reference for that Parameter and convert it to the table.
   1. Now you will get a table with single column and a single row.
3. combine the tables (You can use PowerQuery/DAX) and add a calculated/custom column to identify the table name. 
4. Now using DAX measure you can identify the parameter value.
   1. Example

ParameterMeasure = SELECTEDVALUE('Parameter1 (2)'[Column1])​

• Using this measure you can switch the values 

Measure = 
var __parameter=SELECTEDVALUE('Parameter1 (2)'[Column1])
var __selectedColumn=SELECTEDVALUE('Table'[Column])
var __Table1=CALCULATE(SUM('Table'[Sales]),'Table'[Column]="Table1")
var __Table2=CALCULATE(SUM('Table'[Sales]),'Table'[Column]="Table2")
var __result=IF(__parameter=1&& __selectedColumn="Table1",__Table1,IF(__parameter=2&&__selectedColumn="Table2",__Table2,BLANK()))
return __result​

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[amitchandak]

@Analitika , not very clear .

refer if these can help

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M

or

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

[Analitika]

I need not depending on slicer,but depending on Parameter !!!