Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
There are 18 columns and each columns has at max 5 categorical values. After selecting a particular zip code I want to show only those columns and their values which are of certain categorical value. So, basically I want to filter or put condition and show only those columns in the table visualization that satifies the condition. I guess I need to create a measure for this but not sure how to approach it. if anyone could guide it will be helpful.
Thanks!
Hi, @Abhi_2022 ;
I have some confusion about your description, can you take a simple scene or example, and hope to output the results? With logic.
please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yalanwu-msft
Thanks for the response.
Following is the sample of the table visual I get after selecting a particular region on map or slicer. Now, I don't want all 18 columns to be displayed. I just want those columns which contain values "Very High", "Relatively High" and "Relatively Moderate".
These columns may differ depending on the region I select. For example, in Florida there is no risk of Avalanches at all. So the value for AVLN_RISKR will be NA_NR_ID (NULL basically). Similarly, there are some other risks that are not relevant to Florida, and they will show "NA_NR_ID" values or "Very Low". Therefore, I want to show only the columns relevant to that region and not all 18 columns. Please let me know if you have any questions.
zip | AVLN_RISKR | CFLD_RISKR | CWAV_RISKR | DRGT_RISKR | ERQK_RISKR | HAIL_RISKR | HRCN_RISKR | HWAV_RISKR | ISTM_RISKR | LNDS_RISKR | LTNG_RISKR | RFLD_RISKR | SWND_RISKR | TRND_RISKR | TSUN_RISKR | VLCN_RISKR | WFIR_RISKR | WNTW_RISKR |
12836 | Relatively High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Relatively Low | Relatively Low | Relatively High | Relatively Moderate | Relatively High | Relatively High | Relatively High | Relatively Low | Relatively Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
12853 | Very High | NR_NA_ID | Relatively Moderate | NR_NA_ID | Relatively Low | Very Low | Very Low | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively High | Relatively Moderate | Relatively Low | Relatively Low | Very High | NR_NA_ID | Very Low | Relatively Low |
12861 | Relatively High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Relatively Low | Relatively Low | Relatively High | Relatively Low | Relatively High | Relatively High | Relatively High | Relatively Low | Relatively Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
12911 | Relatively High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Relatively Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Very Low | Relatively Low |
12912 | Relatively High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Very Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
12913 | Relatively High | NR_NA_ID | Relatively Moderate | NR_NA_ID | Relatively Low | Very Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
12972 | Very High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Relatively Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
12983 | Relatively High | NR_NA_ID | Relatively Moderate | NR_NA_ID | Relatively Low | Very Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Relatively Low | Relatively Moderate |
12989 | Relatively High | NR_NA_ID | Relatively Low | NR_NA_ID | Relatively Low | Very Low | Very Low | NR_NA_ID | Relatively Moderate | Relatively High | Relatively Low | Relatively Moderate | Relatively Low | Very Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
16652 | Very High | NR_NA_ID | Relatively Low | NR_NA_ID | Very Low | Very Low | Relatively Low | NR_NA_ID | Very Low | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Moderate | Relatively Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
16666 | Relatively High | NR_NA_ID | Relatively Moderate | NR_NA_ID | Very Low | Very Low | Relatively Low | NR_NA_ID | Very Low | Relatively Moderate | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Low | Very High | NR_NA_ID | Very Low | Relatively Moderate |
16686 | Very High | NR_NA_ID | Relatively Moderate | NR_NA_ID | Very Low | Very Low | Relatively Low | NR_NA_ID | Very Low | Relatively Moderate | Relatively Moderate | Relatively Moderate | Relatively Low | Relatively Low | Very High | NR_NA_ID | Relatively Moderate | Relatively Moderate |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
85 | |
66 | |
52 | |
47 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |