Power BI Report Builder Multiparameter Issue
Hi everyone! Im having troubles with multiparameters. I need to be able to select all with one button, give the user the select all button enable by default and also be able to select multi-options if the user need it. I found some tips but doesnt work for everyting. Im using a dax query. With the next filter it works well if a i want to apply the "All selected" option in the parameter as default, but its is not allowing multiparameter: FILTER(VALUES(Dates[YYYYMM]), VALUE(@Period)= -1 || Fechas[YYYYMM] = @Period) I also tried using RSCustomDaxFilter, it works for multi parameter selection, but cant assign an "All selected" option to filter everyting at once as default. RSCustomDaxFilter(@Period,EqualToCondition,[Dates].[Period],String) I know that i can use the default values query, but im having issues with it, first is showing a list of all the fields, and i need "All Selected", and second, for some other parameter which i need to work as this one, the default values is not working. It like if nothing was selected. Any suggestion on how can i do it? If we can run the dax query with blanks, without selecting anything, instead of using the "All selected" option, is also good. The idea is that in some reports we have to many parameters and we dont want the end user to select everything if they dont need those parameters. Thanks!
What does the Power BI paginated report visual 30,000-value data reduction limit refer to?
Hello Community I am using the Power BI paginated report visual in a Power BI report and passing it parameters. All works well until I pass all values in all parameters then I get the “Too many Values” warning and not all data is returned in the paginated report. As per Microsoft’s link below, "The paginated report visual has a built-in 30,000-value data reduction limit “ https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual What does this data reduction limit refer to? Does it refer to the parameters being passed in or the Paginated report visual resulting tablix fields? How can I calculate it from the parameters that I am passing in? Below is a screen shot showing the parameters passed to the paginated report: I have done many tests but can’t seem to understand exactly what the 30000 limit refers to. Please help as this will be the deciding factor on if I can use the Power BI paginated report visual or I have to use just the paginated report which is far less user friendly when selecting parameters.
