Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

MattSwan

Adding Columns from different tables to dropdown slicer causes Power BI Desktop to hang.

Submitted by on ‎03-01-2023 03:34 AM

When you add a column into a slicer visual which has columns that are from a different table (not necessarily in a relationship), power bi desktop hangs and requires a restart meaning any changes since the last autosave are lost.

 

Crash.jpg

 

Status: Investigating
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎03-01-2023 10:22 PM

Hi @MattSwan 

You mean you had two unrelated tables and then selected one from each of them to add to the slicer and then Desktop hung, causing your operation to not be saved, right?

I don't really understand what you are trying to do with this. Fields from two tables that are not related can't be added to a slicer. Because slicer does not support many-to-many relationships.

Ailsamsft_0-1677738129041.png

Best Regards,
Community Support Team _ Ailsa Tao

MattSwan
Frequent Visitor
‎03-02-2023 12:48 AM

Thanks for getting back to me.

 

It's when I copy a slicer visual to use on another dashboard while retaining that slicer's formatting. It saves time doing this rather than creating the slicer from scratch and applying all of the formattings. However, I'm having to remember to remove the column before adding the new one otherwise it causes power bi to hang and ultimately crash. If I've done a fair bit of work prior to this and after an autosave, it's lost.

 

Regardless, the app shouldn't be crashing in this instance, the slicer should just fail to load any data.

Anonymous
Not applicable
‎03-06-2023 11:56 PM

Hi @MattSwan 

You can see from my screenshot that visual is not displaying, but Desktop is not running down. Maybe your data is large or the selected column contains more complex operations, which causes Desktop to crash. 

When there is more data, it is not suitable for you to operate like this. If the data is not very complex, it is still recommended that you do not add fields that have no relationship in the slicer.

 

Best Regards,
Community Support Team _ Ailsa Tao

Idea Statuses