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

Matrix Preview - include and exclude

Is anyone having issues with the include/exclude in the new matrix preview?  I don't see those options when right clicking on rows.  I'm sure I'm missing something here, but so far I can't see what.

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Matrix Preview - include and exclude

@jackheilpern

 

Hi, The Include/Exclude option only Appears when you have One Level.  (Similar in a chart)

 

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: Matrix Preview - include and exclude

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG

Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu

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

Re: Matrix Preview - include and exclude

Sorry, this didn't really help.  Here is the screenshot showing the version I'm running:

 

Screenshot1.jpg

 

And here is a screenshot of the results in matrix preview:

 

Screenshot2.jpg

 

As this last screenshot shows, the include / exclude options aren't showing up for me.  Perhaps there is some other option needs to be enabled that I've missed here?

 

JH


@v-qiuyu-msft wrote:

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG

Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu



@v-qiuyu-msft wrote:

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG


@v-qiuyu-msft wrote:

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG

Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu



@v-qiuyu-msft wrote:

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG


@v-qiuyu-msft wrote:

Hi @jackheilpern,

 

Which Power BI desktop version did you run? Based on my test in desktop version 2.45.4704.442 64-bit (April 2017), in the Matrix Preview visual, right click the row, both Include and Exclude options are available.

 

q6.PNG

Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu


Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu


Reference:
Use the new Matrix visual in Power BI Desktop (Preview)

 

Best Regards,
Qiuyun Yu


 

Vvelarde Super Contributor
Super Contributor

Re: Matrix Preview - include and exclude

@jackheilpern

 

Hi, The Include/Exclude option only Appears when you have One Level.  (Similar in a chart)

 

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




jackheilpern Frequent Visitor
Frequent Visitor

Re: Matrix Preview - include and exclude

Hmmm.  I missed that.  It's hard to keep up.  Thanks for the help. 

cyclist007 Member
Member

Re: Matrix Preview - include and exclude

Hey @Vvelarde

 

Do you know whats the reasoning/logic behind not allowing to exclude data points say in a scatter plot or in matrix table (that is data at the most granular level). I mean in my use case every once in a while on refreshing the data there is one data point on the scatter pplot that skews the average. It would be nice for my client to see the scatter plot without that one/few data points also. 

 

 

Also is there a trick/way to make the excluded/included data as a page/report level filter. One of the powerful functionality could be to exclude category on one chart and see how other metrics get affected. Basically right now excluding does not affect data on other visuals that are being cross-filtered, and there should be a way to allow it.

 

 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 219 members 2,726 guests
Please welcome our newest community members: