Forum Discussion
Relevant Data in Filters
I am not using Slicers... I am only using the Filters..
Hi ghutchins ,
Can you share some screesnhots around what you are using and trying to achieve?
Always add details to your query for others to understand in a better way.
Thanks,
Pragati
In the Filters Pane I have the following... In the first image nothing is selected for 'AreaName' so no effect on 'Level Name' is expected.
In the second image I have selected 3 choices for 'AreaName', I see that 'LevelName' was not filtered to only include those options that are associated with the 'AreaName'
Pragati11, Anonymous , AllisonKennedy
Hi ghutchins ,
I tried the similar scenario at my end and it seems to work. Consider following example:
Now if I select anything in my 1st filter, 2nd filter reflects the chnage:
Both of my above filters are coming from same table.
At your end, are they in same table?
If they are not in same table, then are they coming from related tables?
Thanks,
Pragati
I have a very busy Star schema that relates all tables to a Details (Fact Table) table, so I guess they are all related.
The options in each filter are coming from a seperate dimension table. I verified the relationships are set up correct.
I think everything is set up to the best known method but I must be missing something.
- The numbers next to the filter selection should reflect the total values in the visual , so your screenshot indicates to me that 1F has 3 values for the selected Areas.
What does your Model view look like with the relationships between these fields?
You might also find it easier to use the slicer, as you can create hierarchical slicers now by putting AreaName in first, then Level in underneath, which is a neat/easy way to filter the report for examples like this one.AllisonKennedy I verified again that any choice in AreaName has no effect on LevelName. I will try to use slicers but my customers demands leave very little room for a slicer. I have no room for a slicer and I know it is not best practice to overfill a canvas with visuals, but i am taking baby steps in that direction.
