To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Good!
I have a table on which I want to make a filter of TOP N starting from a measurement such that:
I am interested in keeping the filter preconfigured in this way, so that users can put the TOP N they prefer (10, 2, 5, 6, etc.).
The problem I find is that this setting does not apply and I have to put a default value yes or yes. Then, if I decide to delete the filter, the field settings also disappear and I have not been able to find a way to link it again from the display mode of power BI service, but I have to switch to the edit mode to add it.
I have already contemplated the idea of putting a very large number, but the maximum is 1000000 and that does not assure me that at some point the data will be affected (I have totals that sometimes will be required to consult without top N).
Do you have a solution to this problem?
@Syndicate_Admin , If a filter pane is available, the user can change it easily and refer back with a refresh. So you can save it with a large value, if that can work for you.
Hello!
Thank you for answering so quickly, but I just think that option I already commented:
"I have already contemplated the idea of putting a very large number, but the maximum is 1000000 and that does not assure me that at some point the data will be affected (I have totals that sometimes will be required to consult without top N)."
Is there no other option?