Forum Discussion

gjohnson900's avatar
gjohnson900
Icon for Helper I rankHelper I
8 years ago

Default SELECTed drop down items based on a formula, not hard-coded values

We've got over 100 clients that we'll need to deploy this report to.  None of them will have the same values in a critical drop down box.  The report contains a Sankey chart.  If I deploy the report with all items selected in the drop down, we'll get this horrible mess...

 

 

If I could somehow manage to only select the "TOP 5" items in the drop down, it would be quite readable...

 

 

The problem is, that I can't limit the Sankey visual to only showing 

 

WHERE zRank <= 5

... because then it won't respond correctly to changing drop down selections.

 

Further, all clients will have different values in this drop down, so I can't use sticky filtering, or a bookmark, since I'd have to touch each report before deploying them.

 

I've already seen this post (and voted it up), but the workarounds don't help. 

 

Looking for ideas/workarounds/commiseration/funny jokes.

 

Please help!

Thanks,

Greg

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Greg,

     

    Since you have known all the tricks, did you try the Visual Level Filter?

    Default_SELECTed_drop_down_items_based_on_a_formula_not_hard_coded_values

     

     

    Best Regards,

    Dale

    • gjohnson900's avatar
      gjohnson900
      Icon for Helper I rankHelper I
      8 years ago

      Yes, thanks.  Well aware of the visual filter.  That was the part in my post where I mentioned I couldn't do that because I want the user to be able to expand beyond the TOP 5 if he/she wants to.  Just looking for an initial filter for 5.

       

      Thanks though.