Post reply

Dynamically generate the categories (dimension members) in a chart using DAX

  • October 11, 2016 at 3:54 am

    #149066

    Hi Folks,

    We want to build a report to show the top 10 or top 5 customers plus the others as a single category. The report also needs to be parameterized by product category, business type, region, etc. The chart type could be a stacked bar chart or also pie charts.

    Example:

    The challenge is to generate the categories or subcategories dynamically using DAX.

    The values cannot be persisted in the dataset, because the needs to react dynamically to either, the ranking number (top 5 or top 10) and the contexts (by product, by business type, region, etc…)

    The equivalent in MDX would be a new dimension member.

    Have you faced a similar challenge?

    Any comment would be appreciated.

    Kind Regards,

    Paul Hernández

  • November 4, 2016 at 4:40 am

    #1910546

    What are you using for reporting, SSRS?

    The only way I can see you do this is if you include a ranking function as part of your query (based on the parameters), and use the returned rank to dynamically create the groups in SSRS (if that is what you're using).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply