Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Issue with filtering through visuals when using custom column in field parameter

I'm having an issue where I have multiple bar charts, with the exact same field as x axis, and a field parameter as Y axis. 

Issue is when I click on a X-axis category to filter, I get an error. But, filtering that same category through a slicer it works. 

 

Explanation of what I've done:

In the Field Parameters I'm using a custom column for changing between sum and avg. 

So I have multiple measures I want to show on the charts on the page, and want to switch between seeing these measures as either sum or avg. 

 

Example:

Measure name:Custom column for grouping
Measure X (sum)Sum
Measure X (avg)Avg
Measure Y (sum)Sum
Measure Y (avg)Avg
Measure Z (sum)Sum
Measure Z (avg)Avg

etc

 

I'm then using a slicer with this custom column for switching between showing Sum or Avg.

 

For each visual I then have only selected either Measure X, Measure Y, etc. which allows me to switch between Sum/Avg and still having correct measure displayed for each visual. This works perfectly 

 

However here comes my issue. 

 

When I'm using a slicer for filtering X-axis (slicer and x-axis is same column) it filters as intended. BUT, when I instead click on a catagory in the X-axis on a visual, I get the following error: "Can't determine the relationship between the fields", which is weird no? 

The measures are all from the same fact table, and the x-axis/categori is from another table with a 1-* relation. 

Any suggestions on what's wrong and how to fix it?

Thanks!

 

Need Help

2 Replies

  • littlemojopuppy's avatar
    littlemojopuppy
    Community Champion
    2 years ago

    Anonymous by chance did you create a table to support this visual?  First...that's very bad form.  But if you did, it sounds like there isn't a relationship between whatever is on the X axis and that table.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      littlemojopuppy  Thanks for the reply, 

      I used the create field parameters function or whatever you call it, which automatically makes a sort of table. 

       

      But like I mentioned filtering through slicers works, just not through the bar on a visual.

      So I'm not enitrely sure that relationship is the issue?

      When using the parameters without the extra column in the visual, filtering through clicking on bar chart works.