Filtering by rows instead of colums with DAX

[DAXhelpAcc]

Is there any way to filter rows in power BI? And is there any way to pick a certain row(lets say i need the 3rd row of a table only)? Also wanted to ask whether it is possible to filter by rows like you can filter by columns.

Situation:

1. I have a table from excel that looks like this:

 What i have to do is to check whether one of the users on the date needed (dates start from the 7th column) have a value 1, 2 or null when i get one of the values (1,2,null) i have to go to the next table:

And in the column "Vacation" I have to insert a value Yes No (based on wherether i get 1,2 or null).

So i don't really know how i can get the value when i have to check the dates which are in the 1st row and the users which are in the 1st column.

Thanks in advance.

[v-yulgu-msft]

Hi @DAXhelpAcc,

You can create a measure to check whether a person has a break that returns 1 or 0. Then, you can add this measure to visual level filter and specify its value, so that the visual will be filtered based on specific rule on row level.

Besides, it would be better to share smaple data and show us desired result.

Regards,

Yuliana Gu

[Greg_Deckler]

First, sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, you would need to add an index in your query to be able to pull out specific rows. I'm not sure that I understand your question around filtering by rows though, the scenario that you are presenting seems easily an application of filtering based upon information in columns.

[DAXhelpAcc]

Kind of hard to ask the question when i don't even know how to aproach this problem. But i tried to make ir more detailed thank you for the information. Can you explain about the index? how does it work?

[v-yulgu-msft]

Hi @DAXhelpAcc,

The source table from Excel is not readable and editable after being imported into desktop. Please adjust the table structure in source file, similar to below.

From

To

In Power BI desktop, please refer to below steps applied in Query Editor mode.

Prompt headers.

Replace null with number 0 or any other numerical value for those columns after Column7.

Select all columns from Column7, click unpivot columns.

Add a conditional column.

Save all above changes, and return back to Data View mode. For "And in the column "Vacation" I have to insert a value Yes No (based on wherether i get 1,2 or null).", please use LOOKUPVALUE function.

Best regards,

Yuliana Gu