Get selected value from slicer to use it on line chart's x axis

[alpunlx]

Hello, I'm trying to get a value from the Slicer that I selected to use on the Line chart's x axis. But it doesnt work. I've created a column with a parameter to add those values to Slicer.

What im doing here is getting the weight from the table for example 2224 and divide it with selected value of Slicer and subrtact the decimals from that result by using INT() and than multiply it with the result.

This is the column that i use for run my function here

This is the measure one

And the problem is if i want to use Column, the value doesn't get transferred to the table. but if i want to use the Measure it transfers but i cant put it on the X Axis. The column can't get the value in real-time to the table.

I've searched for the Column one and i found this information:

The image of multiple tables that i want to transfer data in: 

So what can i do about it to transfer data to table?

I've tried to search about what i wanna try and found a way to fix it.

[Anonymous · Accepted solution]

Hi @alpunlx,

Current you can't create dynamic calculated column/table based on filter selections, they do not work on the same data level, and you can't use child level to affect their parent.

Notice: the data level of power bi(from parent to child level)

Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

Since you can only use measure expression to interact with filter effect. I'd like to suggest you create an unconnected table with raw table axis values.

Then you can write measure formula with if statement to check the filter selection and current axis to prevent the calculation on not wanted ranges.(power bi will auto hide the axis not have correspond values)

Regards,

Xiaoxin Sheng