Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We have connected Power BI to SSAS - Connect Live Option
We are trying to create one report where a specific filter condition needs to be added (too many values in filters)
eg : Column1 , Column 2 , Column 3 , Column 4 --- in Report View
where Column4 = Value 1 , Value 2 , Value 3 , Value 7 , Value 9.....Value 98 --- Filter Condition
In filtering , i have the option to click on check boxes for different values..(Value1 , value2 etc) but it becomes very tedious when we have more values (say 90 values)
Is there any better option to do?
Hi @GuestUser ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @GuestUser ,
You may choose an appropriate filter type for your visual fields in Filters pane, see more: Power BI Filter Pane.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have you tried the below settings.
If you have any queries, please let us know.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?
BR,
Venal.
Thanks !!
But my question is how can we add/select multiple values in filters in an easy manner (when i have more values like if have to select 98 values out of 200) while creating a report
Currently I am clicking on each checkbox which is quite time consuming
Any suggestions pls?
I recommend adding a filter to all pages or the whole page if the filter is consistent.
Otherwise, it may be worthwhile to create an excel file with a helper column, upload that, create a relationship, and filter based on the helper column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.