Sampling based on column values

[Anonymous]

Below is the sample format of my data.

Requirement: Have a checkbox filter  with entires "SIT", "UAT", "PRPEROD".

Once the user selects any option only rows with corresponding Yes should be shown in a table.

Ex: If user selects "SIT" only rows eith "Yes" under "SIT" column will be displayed

    If user selects "SIT", "UAT" only rows with "Yes" under "SIT" and "UAT" columns will be displayed in the same table

Data:

[lousegers · Accepted solution]

Hi @Anonymous ,

If I understood your request correctly, I would suggest to tackle this issue as follows:

1) Unpivot Columns SIT, UAT & PREPROD resulting in the following table

2) Designing your PBI report while adding a page filter, which excludes any "No" statuses.

I hope this solves your issue!

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo.

Hop on the data train and get connected @LouSegers

[Anonymous]

Hi @lousegers ,

Thanks for your reply. Can yopu give any reference for achieving the first step please?

1) Unpivot Columns SIT, UAT & PREPROD resulting in the following table

Regards,

Mahesh

[lousegers]

Hi @Anonymous ,

You can just select the three columns (SIT, UAT & PREPROD) & select the "unpivot column" option. 🙂

If you would like to have more background information on how data pivoting actually works I can only advice taking a look at one of the following links, both very explanatory:

https://radacad.com/pivot-and-unpivot-with-power-bi

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

I hope this image clears things up on the part of unpivoting your data. 

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo.

Hop on the data train and get connected @LouSegers

[amitchandak]

@Anonymous , there are from the same table LOv should filter.

Or you can create a hierarchy to make sure that happenss

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

or try Hierarchical slicer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchical_slicer

This one, when they are not from same table

https://www.youtube.com/watch?v=cyOquvfhzNM

[Anonymous]

Thanks for your reply. There is no hierarchy relation between these columns. they are independent