Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter not working as expected

Hi,   I created a new table using summarizecolumns() and both the new table and source table have a column "Type". I have a dropdown filter for Type on the page which is not impacting the values of...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi v-kelly-msft, 

 

I can only attach the screenshots since I don't have an attach file option available. The slicers for type and date are from original table and the graph needs to be filtered by both the slicers which is not happening. The only relationship allowed between "Type" of the tables is many to many and then the graph does not get filtered by the date slicer. I tried creating columns in both the tables to have matchable dates - monthly 1st date in original date and a combinevalue column in summarized table and then create a relationship which is not accepted.

 

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi  Anonymous ,

 

Is your issue solved？Does my suggestion work ?

Best Regards,
Kelly

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Apologies for the delay in response, but a one to one relationship is not being allowed between "Type" and thus am not able to resolve it using this, thanks for your response.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  Anonymous ,

     

    No,what I mean is to create a dimensional table between the 2 tables then create a one to one relationship as my sample show it.

     

    Best Regards,
    Kelly

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-kelly-msft,

    As I mentioned before, a one to one relationship is not being allowed between the "Type" dimension table and the other Table1 and Table2.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Relationship is not the key factor,could you pls provide some sample data with expected output for test?

     

     

    Best Regards,
    Kelly

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

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-kelly-msft,

    What essentially happens is this:
    There is a table "A" which consists of id, type, date, a few questions.
    Another table "S" consists of id, type, date (month and year format) with the number of types per month.
    I need to plot a graph for number of A per month and S per month.
    But A doesn't directly have number of rows per month, for which I use SUMMARIZECOLUMNS to achieve the same (say R).
    The page has filters from A (type and date) which need to be able to filter out the graph consisting S and R.
    A isn't filtering out R itself even with a many to many relationship between types.
    Attaching screenshots for A and R.

    Original dataSummarized data