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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
andreazambon
Helper V
Helper V

Filtering data using graph column.

Hi there. 

 

I?m actually courious to kown if I can filter data simply selecting a column of a graph. 

 

I have 2 graphs, one with events name in X-axis, and double values:

-Duration of events in columns

-numbers of events in a row.

 

andreazambon_0-1666274389841.png

 

 

In the second one, I have the same informations but with weeks in X-axis.

 

Actually, if I select a event in the first graph, this is what happens: as you can see, it actually filter the data but not in the way that I need:

 

andreazambon_1-1666274472894.png

 

What I need, by selecting a column, is this (in the second graph):

andreazambon_2-1666274536302.png

 

Now i just use a filter view to do the job, but will be easier with column selection.

 

 

Is that possible?

 

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @andreazambon,

 

In your case, the interactions between the visuals are set to highlight. You can use columns as filter by going to Format->Edit Interactions and changing the interaction type to Filter.

 

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

View solution in original post

1 REPLY 1
Shaurya
Memorable Member
Memorable Member

Hi @andreazambon,

 

In your case, the interactions between the visuals are set to highlight. You can use columns as filter by going to Format->Edit Interactions and changing the interaction type to Filter.

 

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: How to Export Telemetry Data from Azure IoT Central into Power BI

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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