Hiding some subcategories in a matrix visual

[jpg_ramalho]

Hello, I've been building a matrix visual in order to showcase the different types of issues in JIRA projects (business and software projects to be exact). The datasource from where im pulling the data (Power BI Connector) has this main table called "Issues" which lists all of the incidents. Some of the issues will have a parent key which links them with their parent issue, but this is done recursively in this single table.

I've created with the help of conditional column, a hierarchy and categorized each issue accordingly to its level in the hierarchy, as this table suggests:

Issue Type	L1	L2	L3
Epic	Summary	BLANK	BLANK
Story	P_Summary	Summary	BLANK
Subtask	P_P_Summary	P_Summary	Summary

But doing it this way introduces some blank values, I'm aware.

When I pull these layers into a matrix visual in order (L1,L2,L3) they represent the hierarchies correctly, but when I unfold the 1st level, the 2nd level will always have a blank entry, (alongside the others which are correct), and the same behaviour for the 2nd level. When unfolded, there will be a blank entry for the next subcategory, like this:

I know that there is a feature on the matrix visual by right clicking on the line and then selecting "Exclude", but is not there a way to do it for all the entries at once?

Best regards,
Thanks in advance! 🙂
João


 

[v-kpoloju-msft · Accepted solution]

Hi @jpg_ramalho,

Thank you for reaching out to the Microsoft Fabric Community Forum. Thankyou @SamWiseOwl, for your inputs on this issue. And, I have identified few workarounds that may help resolve the issue. Please follow these steps:

Power BI includes all unique combinations of values in the hierarchy, including those with blanks. As a result, you will observe:

• Epics → expected stories plus one blank line (for story rows where L2 is blank)
• Stories → expected subtasks plus one blank line (for subtask rows where L3 is blank)

These blanks occur due to the hierarchy's structure, where lower-level issue types have blank values in higher-level fields.

Option 1: Apply Visual-Level Filters at Each Level:

Select the matrix visual. In the "Filters on this visual" pane, drag in L1, L2, and L3 fields (if not already present). For each field, click the filter dropdown and uncheck the “(Blanks)” box. This will eliminate blank rows at each level.

Option 2: Develop a Measure to Filter Blank Paths:
This approach enables you to implement a dynamic filter based on custom logic:

ShowRow =

IF (

    ISBLANK(SELECTEDVALUE(Issues[L1])) &&

    ISBLANK(SELECTEDVALUE(Issues[L2])) &&

    ISBLANK(SELECTEDVALUE(Issues[L3])),

    0,

    1

)

Next, incorporate this measure into the filters pane of your matrix. Configure the filter condition to: ShowRow is 1.

If you need any further assistance, feel free to reach out. If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[v-kpoloju-msft]

Hi @jpg_ramalho,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[SamWiseOwl]

Hi @jpg_ramalho 

Can you provide a little more mock data or a PBIX file with the issue replicated.

I assume its similar to an issue I have had.

Some of my assignment levels don't have a 9th level so PBI returns a blank.

They will continute to be blank until I get to a level where there is a value.

Then when I get down to another branch I may find another blank.

Alternatively you might have this setting turned on: