Dynamic x-axis adjusted by slicer

[sparker95]

I am not sure how to upload my model so please see my images. 

I have a dynamic x-axis which needs to adjust according to the slicer on the page 'Model Name'. I am able to use this as an x-axis on a scatter graph if I use alongside my Values column (see Graph 1). However as on Graph 2, I want to add different series to my graph as I have done in Graph 2. However in Graph 2 there is not a way for me to use my 'dynamic x-axis values' as the x-axis. 

[v-pgoloju]

Hi @sparker95,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kuma

[v-pgoloju]

Hi @sparker95,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Create a separate table for the x-axis using GENERATESERIES() with a full range of values. This table won’t change when you use slicers, but that’s okay you’ll handle slicer filtering inside each measure using DAX. So even if the x-axis stays the same, the lines on the chart will still respond correctly to your slicer selections.

If you found this information helpful, please consider marking the response as accepted and giving it a thumbsup. This will help others who may have similar questions. If the issue persists, feel free to reach out to us, we are here to assist you.

Warm regards,
Prasanna Kumar

[sparker95]

Hi thank you for your response, my issue with your solution is by creating a dynamic axis as you have done in a seperate table, it is not responsive to the slicers on the page. As slicers don't affect calculate tables/columns

[v-pgoloju]

Hi @sparker95,

Thank you for reaching out to the Microsoft Fabric Forum Community. And aslo thanks to @DataNinja777 for promt and helpful solution.

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[DataNinja777 · Accepted solution]

Hi @sparker95 ,

To create a dynamic x-axis that adjusts according to your slicer selection and supports multiple series, you need to use a disconnected table for the x-axis values and link it via dynamic DAX measures. First, generate a disconnected table for your x-axis range dynamically, for instance:

DynamicXAxis = GENERATESERIES(MIN('YourTable'[XValue]), MAX('YourTable'[XValue]), 1)

Next, for each series measure (e.g., predictions, benchmark values), create dynamic measures using the disconnected axis. For example:

BenchmarkValue = 
CALCULATE(
    SUM('YourTable'[BenchmarkValue]),
    FILTER('YourTable', 'YourTable'[XValue] = SELECTEDVALUE(DynamicXAxis[Value]))
)

Apply this pattern for each series you wish to visualize, replacing the relevant measure columns accordingly. Now, place the disconnected table (DynamicXAxis[Value]) onto your visual's x-axis, and your dynamic measures on the y-axis. This approach maintains responsiveness to your slicer selections, enables multiple series display, and resolves the limitation you're facing.

Best regards,