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 ...
Need Help
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.