Field paramater group shows all measures within that group multiple times

[GijsBI]

Hi, 

I've created a field parameter containing 9 measures and three groups: group 1, group 2 and group 3. I use these groups to allow the user to filter adjust the visual based on the group they want to see. Now, I want to create a bar chart which contains the data for the selected group (measures 1 to 3). When I create a clustered bar chart, each measure is shown three times instead of once. How should I adjust the visual to have each measure shown only once?

Field parameter creation

Each measure appearing three times

[Ritaf1983]

Hi @GijsBI 

You're seeing each measure appear three times because you're placing the field parameter on the X-axis.
However, when using a field parameter that contains measures, you should not place the parameter on the X-axis.

Instead, just place the field parameter in the Values section of the visual.
Power BI will automatically show one bar per measure — only once per measure — for the selected group.

So the fix is simple:
Remove the field parameter from the X-axis.
Just keep it in the Values section of your clustered bar chart.

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[GijsBI]

Hi Ritaf,

Thank you for your response. This already helps, thanks a lot. I'm still looking for a way to add the measure name on the X-axis while removing the repitition of measures. Do you know if that's also possible? I've added a screenshot that hopefully clarifies what I mean. Thanks for your help in advance. 

[Ritaf1983]

Hi @GijsBI 
In this case try to use dynamic measure instead of field parametr.
Take a look at my solution in the linnked discussion.
The logic seems the same
https://community.fabric.microsoft.com/t5/Desktop/three-separate-amp-quot-Y-axis-amp-quot-with-share...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[GijsBI]

Hi Rita, 

Thank you for your response. Since the data that I'm using is sequential (it's process related data), I do not prefer to have small multiples, since it is harder to see the sequence of the processes. Hence, I want to have the clustered bar chart where I set the order of the processes on the X-axis. 

[v-aatheeque · Accepted solution]

Hi @GijsBI ,

If you want to display only the measures, remove the Group field; otherwise, keep it if you want to filter by group. If you are expecting to show only one measure at a time, use the Measure field in a slicer and set it to single select so that it displays only one measure at a time.

FYI : kindly check the below screenshot.

Hope it helps !!

[v-aatheeque]

Hi @GijsBI 

Just checking in to see if the suggestion provided earlier the was helpful  specifically about using the Measure field in a slicer (set to single select) and optionally removing the Group field to better visualize your sequential process data in a clustered bar chart.

Let me know if you were able to apply that or if you need any further help!

[v-achippa]

Hi @GijsBI,

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue is resolved or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @GijsBI,

Thank you for reaching out to Microsoft Fabric Community.

Thank you for the response, here the issue is likely because of the field parameter is on the X-axis, this evaluates each row in the parameter table separately even within the same group.

• Put the field parameter only in the Values section, do not put it in the X-axis.
• Use the Measure name column from the parameter table as the X-axis.

Now each measure will be evaluated dynamically by the parameter and the X-axis will show each measure name only once for the selected group.

If any post helps in resolving the issue, 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! 

Thanks and regards,

Anjan Kumar Chippa

[GijsBI]

Hi Anjan,

Thank you for your response. In the above screenshot that I shared, I already placed the measure name from the parameter table on the X-axis and the parameter values in the values section. This unfortunately didn't solve the problem.

[v-achippa]

Hi @GijsBI,

Thank you for confirming. Since you have already placed the measure name on the X-axis and still see duplicates, here the issue is likely due to all parameter rows still being processed, not just those from the selected group.

Please create a new column in your field parameter table like below:

Measure Axis Label =
IF (SELECTEDVALUE(testFieldParameter[nortime_group]) = testFieldParameter[nortime_group],
testFieldParameter[Measure name],
BLANK()

)

Then use this new column on the X-axis. This make sure only the selected group's measures are shown each exactly once.

If any post helps in resolving the issue, 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! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @GijsBI,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response resolved your issue, please mark it as "Accept as solution" and give kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[GijsBI]

Hi, 

I didn't have the time yet to check if this solution worked for me. I will come back to you as soon as possible. 

[GijsBI]

Hi Anjan,

I've implemented your suggestion, but the "Measure axis label" stays blank. It seems that the selectedvalue function does not give a value when you use it within a table. I checked with a measure if the selectedvalue gave the answer that I expected, and it did. This results in a "(blank)" X-axis label. I've added the screenshots so you can see what happens.

[burakkaragoz]

Hi @GijsBI ,

This usually happens when the field parameter is used in both the axis and legend (or another visual element that causes repetition). Power BI ends up cross-joining the values, which leads to each measure showing multiple times.

Here’s what you can try:

• Check your visual setup: Make sure the field parameter is only used in the axis (or values), and not duplicated in legend or tooltip.
• If you're using a grouping column (like "Group 1", "Group 2", etc.), try removing that from the visual entirely — it might be causing the repetition.
• You can also add a filter to the visual to only show the selected group, instead of letting all groups render at once.

If you're still seeing duplicates, try using a slicer to filter the field parameter to just one group at a time — that usually clears it up.

Let me know how it goes!

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

translation and text formatting supported by AI assistance

[GijsBI]

Hi Burakkaragoz,

Thank you for your response. Unfortunately, your solution did not work for me. Have a great day.