Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Help with TOPN in charts

Hello

I need help with the TOPN filter because it brings more of the data in the chart according to what I indicate, and I understand that it is because the last value is being repeated. Here's an example:

I know that it is possible to use the RANKX function, but I do not know how to apply it since the counts are made in the same graph.

Can you help me?

Thank you!

1 Reply

  • foodd's avatar
    foodd
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Please create a pbix file that contains some sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the pbix to Onedrive or Dropbox, and share the link. Please use Excel to create the sample data instead of the manual input method share the xlsx as well.

     

    Describe the expected results based on the sample you provide.