Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
DanS446
Frequent Visitor

How to better work with this data (slice or filter it)

Greetings, i have this data where i evaluate some conditions on 3 different weeks, so the columns repeat and are separated visually by the green columns.

 

I can work fine with the data, doing count, clasifying it, etc.

*Sorry most info is hidden, its spanish anyways.

 

i made new columns to group all the same conditions on different weeks so i can show them on a ring graph, i can slice the info by Risk (Riesgo), and Week (Semana), and info on the visuals get sliced. What i cant do is to slice the other visuals by clicking on the ring graph, i usually create a new paramenter with all the columns i want to make a slice, but is not working. I wouldnt want to unpivot columns for this.

 

The problem is how the data is arranged, like a table and filling it with 1s and 0s, and that i need to filter/slice by columns instead of row data like usual.

DanS446_0-1708970410142.png

DanS446_2-1708970700491.png

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@DanS446 , All visuals should filter other visuals, unless you stopped interaction. But, if you have created a visual, say pie only on measures no legend. then it will not filter other visual

 

Pie, visual has default interaction as a highlight when filtered by other visual, which means it will only fill. You can change that to filter using edit interactions under format

 

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

Thanks, i noticed it needed the other field for it to work, but since the data is from many columns i cant seem to find a way to keep the same display arrangement with legends field. The chart expects you to have a single column with different data. Im not sure if i could have the data in a different way, like just one column as "status" and a different number value to represent each of my columns (since they fill with a 0 or 1). The problem is that a single row item can have many of the columns status at the same time, and i dont think you can put mutiple values on a column and then filter for "any containing X", like using "text.contains" but for a filter/slice, ill try if a filter with bookmark as a button does the job.

 

Even for doing a slicer, if i add multiple fields it just try to use first as a parent and the rest as nested childs, i had to do a separate slicer for N-2. N-1, N, to filter the data by any of those.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.