Forum Discussion
Sampling based on column values
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:
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
5 Replies
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_eTYor try Hierarchical slicer
This one, when they are not from same table
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
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
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
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
