Field Parameter slicer have to work as x-axis and legend --

[Jaya_p]

I have two field parameter slicers and one column chart. The first field parameter contains different columns, including a "None" option (which is blank). The second field parameter contains only two columns that are not part of the first field parameter.

Here's what I want to achieve:

• When "None" is selected in the first slicer, the selected column from the second slicer should be used as the x-axis in the column chart.

• When any other option (other than "None") is selected in the first slicer, the selected column from the second slicer should be used as the legend. Please help with this .   

• I have a tooltip in the column chart that should appear when hovering over the visual.                  @OwenAuger  , @rajendraongole1 @Deku  @bhanu_gautam 

[v-bmanikante]

Hello @Jaya_p ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@johnbasha33 Thank you for your quick response.

As @johnbasha33  mentioned, you’ll first need to create two field parameters — one for the X-axis options (including a “None” selection) and another for the legend options.

However, due to current Power BI limitations, dynamic switching between X-axis and Legend in a single visual isn’t natively supported.

You can achieve the desired behavior using two separate charts and Bookmarks:

Chart A:

Use the first field parameter (fp1) as the X-axis.

Use the second field parameter (fp2) as the legend.

Chart B:

Use the second field parameter (fp2) as the X-axis.

Keep the legend blank or hidden.

--->Then, use a Bookmark + Button toggle setup to switch between Chart A and Chart B dynamically based on whether "None" is selected in the first slicer.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
B Manikanteswara Reddy

[Jaya_p]

Here slicer is dropdown type , How do we manage, we can arrange bookmarks for that. And I need tooltip for both charts

[v-bmanikante]

Hello @Jaya_p ,

Apologies for the delay in getting back to you!

Thanks for the update!

You're absolutely right that we can't use bookmarks to switch visuals based on dropdown slicer selections, since bookmarks don’t respond dynamically to slicer values. But we can still achieve what you need using a simple trick with measures and visual filters , no buttons or bookmarks needed.

We’ll create a small DAX measure that checks if “None” is selected in the first slicer. 

IsNoneSelected =

IF(

    SELECTEDVALUE('FieldParam1'[FieldParam1]) = "None",

    1,

    0

)

• Then, we build two versions of the column chart:One chart shows the first slicer’s column on the X-axis and the second slicer as the legend and The other chart shows the second slicer’s column on the X-axis, with no legend.
• Using visual-level filters, we control which chart is visible depending on the slicer selection.
• Since both are regular visuals, tooltips will still work fine for both.

So in the end, the correct chart will show automatically based on the slicer selection, and your tooltip requirement is fully supported , all without any bookmarks or buttons.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[Jaya_p]

While we are using two charts, when front visual chart blank for slicer selections, we can't get tooltip for background visual chart.

[v-bmanikante · Accepted solution]

Hi @Jaya_p ,

Apologies for the delay in getting back to you

Thanks for the follow-up , and you're absolutely right.

When one of the charts is blank and sitting on top of the other, Power BI won’t let you interact with the chart behind it, so tooltips won’t show up either. That’s a known limitation when using layered visuals to simulate dynamic switching.

Since Power BI doesn’t yet support changing the X-axis and Legend dynamically in a single chart, here are a few workarounds that might help:

1. Place both charts either side by side or vertically (not overlapping). Then use a DAX measure like IsNoneSelected as a visual-level filter to show only the relevant chart. This way, the visible chart is fully interactive and tooltips work as expected.

2. Create a dedicated tooltip page in your report and assign it as a report tooltip for both visuals. This helps ensure the right tooltip appears when hovering, even when switching between visuals.

If the issue still persists, I’d recommend raising a support ticket with Microsoft. The support team can look into the backend and provide more in-depth assistance tailored to your environment.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Jaya_p ,

Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

Warm regards,

B Manikanteswara Reddy

[Jaya_p]

I have two field parameter slicers and one column chart. The first field parameter contains different columns, including a "None" option (which is blank). The second field parameter contains only two columns that are not part of the first field parameter.

Here's what I want to achieve:

• When "None" is selected in the first slicer, the selected column from the second slicer should be used as the x-axis in the column chart.

• When any other option (other than "None") is selected in the first slicer, the selected column from the second slicer should be used as the legend.Please help with this challenge

[Jaya_p]

I have a tooltip in the column chart that should appear when hovering over the visual.
Other way, Do u have any idea by creating bridge table (x-axi col, legend col), relationships

[johnbasha33]

@Jaya_p 
You can absolutely achieve this dynamic behavior in Power BI using field parameters, a little bit of DAX logic, and a well-set-up column chart

[Jaya_p]

Thanks a lot for this solution! But I have a tooltip in the column chart that should appear when hovering over the visual.

[johnbasha33]

@Jaya_p 

You have:

• Field Parameter 1 (let’s call it fp1) with multiple fields + a "None" option (blank/null).

• Field Parameter 2 (let’s call it fp2) with 2 fields (used as x-axis or legend).

• One column chart that:

  • Uses fp2 as x-axis if fp1 is "None".

Uses fp1 as x-axis, and fp2 as legend, when fp1 is anything else.

Step 1: Set up your Field Parameters (if not already)

• Go to Modeling > New Parameter > Fields

• Create:

  • fp1 with fields + a dummy None (can be BLANK() or a dummy column like "None").

  • fp2 with 2 fields only.

Each of these creates a table: fp1_table, fp2_table.

🔹 Step 2: Create a measure to switch axes

You'll create 2 calculated columns or measures to handle dynamic behavior.

A. Determine if fp1 = None

IsNoneSelected =
VAR selectedLabel = SELECTEDVALUE('fp1_table'[Name])
RETURN IF(selectedLabel = "None", TRUE, FALSE)

Step 3: Add logic in the visual

Now, the tricky part is Power BI doesn't allow dynamic swapping of visual roles like x-axis or legend directly in visuals based on slicer logic.

But here’s how you can work around it:

Option 1: Create two visuals and toggle visibility

• Chart A:

  • X-axis: fp2

  • Legend: (none)

• Chart B:

  • X-axis: fp1

  • Legend: fp2

Then create a measure like
ShowChartA = IF([IsNoneSelected], 1, 0)
ShowChartB = IF([IsNoneSelected], 0, 1)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!