cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Visual Filter on Matrix Column

Hi,

 

I have a matrix that requires a visual filter (it's a 1 or 0 flag that gives me month to date compared to this time last month and this time last year on the same month). 

 

For asthetic reasons the matrix needs to have the dates in the columns along the top. As soon as I move them from row to columns the visual filter no longer works. Apparently the visual filter on a matrix only applies to rows.

 

Is there any way to make a visual filter apply to columns on a matrix?

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Visual Filter on Matrix Column

Hi @doodlelurch 

It seems you may use 'Unpivot columns' to model your data or create measures to get it.Sample data and expected output will be helpful to provide an accurate solution.If you need further help,please follow the How to Get Your Question Answered Quickly to post your simple assumed data and expected output.

Reference:https://community.powerbi.com/t5/Desktop/Filter-by-Column-heading-in-matrix-visual/td-p/330344

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Visual Filter on Matrix Column

Hi @v-cherch-msft, thanks for the reply. 

 

Ok, apologies maybe I did not include enough detail. 

 

I'm using the following DAX measure:

 

Flag = IF(ISBLANK(min('Month to Date'[This Month]))&&isblank(min('Last Month to Date'[Last Month]))&&isblank(min('Last Year to Date'[Last Year])),0,1)

 

I want to then filter the 1s so the dates on the columns only appear if they have a 1 on the Flag measure.

 

It works perfectly when the date hierachy is on the rows, but as soon as I move it to columns it ignores the visual filter. 

Microsoft
Microsoft

Re: Visual Filter on Matrix Column

Hi @doodlelurch 

Could you share some data sample or some screenshots?

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors