Dynamic Calculation of the X-Axis in a Line Chart

[MoritaNaohito]

I’m displaying a line graph with elapsed time on the X-axis and values on the Y-axis. I want to use a slicer to select a speed parameter from a different unrelated table, multiply the selected speed value by the elapsed time to get the distance, and then use this distance for the X-axis. When the slicer selection changes, the X-axis should dynamically update.

However, I’m having trouble multiplying the selected speed value with the elapsed time using new measures or columns created with DAX.

Could you please help me with how to implement this?

[v-venuppu]

Hi @MoritaNaohito ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @MoritaNaohito ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Ritaf1983]

Hi @MoritaNaohito 
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[MoritaNaohito]

Thank you for your advice.

I have two tables, Table1 and Table2, as shown below.
I would like to use a slicer to select a Category from Table2, filter Velocity to a single value, and use the selected Velocity (V1) to plot a line chart with the X-axis as Time_seconds × V1 and the Y-axis as y-value.

I expect the X-axis values to be dynamically recalculated when switching the selected Category.

Thank you in advance for your support.

Table1:

Time_soceonds	y-value
0	28.5
0.093	28.4
0.209	28.7
0.414	28.7
0.535	28.6
0.64	28.5
0.761	28.6
0.854	28.4

Table2: 

Category	Velocity
A	0.1
B	0.2
C	0.3
D	0.4

[tharunkumarRTK]

@MoritaNaohito 

One possible approach is to create a cross join between, table 1 and table 2.

In the new table:

create a new column to multiply table1[Time_seconds] column with table2[Velocity].

You can use this new column as your x axis,  y-axis value as y-axis column. 

Category column in the slicer. 

This can fullfill your requirement, but creating a calculated table and column can degrade your model performance. I will not recommend this option if you are handling large volumes of data. May be you can prepare such table in your datasource itself 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[MoritaNaohito]

@tharunkumarRTK 

Thank you for your reply.

Cross join seems to be one possible solution, but since both Table1 and Table2 are large tables, the update process takes a very long time.

As modifying the original tables is not suitable, it seems that using DAX to create a new column or measure would be necessary. I tried using SELECTEDVALUE('Table2[Category]'), but it did not work as expected.

If you have any other suggestions, I would appreciate your advice.

[tharunkumarRTK]

@MoritaNaohito 

You can put a DAX measure in x axis. You need a physical column in a table to use it in the x axis. 

as you cannot do a cross join of the full table, I would suggest you to perform this power query with the columns that are required. 

I replicated your scenarion in a file and I am attaching it, please have a look and I hope it helps

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[MoritaNaohito]

Thank you for providing the sample.

However, since this method performs a cross join, it takes too long to update with the actual data, making it impractical.

The only approach I could think of was to define a parameter (Velocity) in Power Query, as shown in the attachment, and manually update the parameter before refreshing the data.

This method is not ideal because the filter on Category does not work due to the manual parameter update, and every time the parameter is changed, the data needs to be re-imported.

Calculated x axis without cross join.pbix

[v-venuppu]

Hi @MoritaNaohito ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.

Thank you.