Forum Discussion
Solved
create dynamic axis based on two slicers
Hi Community We have a following requirement to be achieved based on the filter Selections in Power BI. we have two filters Filter one- Selected Institute Filter two -Cohort Institute We ...
Hi esingh,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.
Hi
Sorry for delayed response. The data is attached. Please refer slicer table for creating slicer on Selected insitute and cohort.
Requirement:
Selected Institute- Single Selected filter on Insituiton name.
Cohort Insitute- Multi select filter on Institution name.
Selected Insitute will be not available in Cohort Institute slicer mutilselect for selection again.
We want to build a visual where values from both filter can be passed into the bar chart. The visual axis should show Your Response for Selected Insitute and Institute 1, Institute 2, Institute 3, Institute 4 etc. based on the cohort filters Insitute Selections.
The Green base is for the selected instute and blue for cohort. In the axis label we are looking for Insitute 1, 2 ,3 etc. dynamically ( based on the instiute selected in cohort slicer) and your response for green bar.
thanks
Slicer table:
| ORG Type | institution_name | institution_code | year | |
| Academic Medical Center (AMC) | Nexora Technologies | 1003 | FY2024 | |
| Academic Medical Center (AMC) | BluePeak Solutions | 1004 | FY2024 | |
| Academic Medical Center (AMC) | Quantix Systems | 1005 | FY2024 | |
| Academic Medical Center (AMC) | Veltrix Innovations | 1006 | FY2024 | |
| Research Institute within a Health System or AMC | Zentara Labs | 1010 | FY2023 | |
| Research Institute within a Health System or AMC | Corevia Health | 1010 | FY2024 | |
| Standalone Cancer Center | Lumora Analytics | 1010 | FY2021 | |
| Standalone Research Institute | Trivanta Group | 1010 | FY2022 | |
| Standalone Research Institute | Omnexis Corp | 1015 | FY2024 | |
| Hospital / Health System | Fintara Ventures | 1022 | ||
| Academic Medical Center (AMC) | Solvexon Ltd | 1026 | FY2024 | |
| Matrix Cancer Center (within an AMC) | Auralis Dynamics | 1027 | FY2021 | |
| Research Institute within a Health System or AMC | Hexora Biotech | 1030 | FY2024 | |
| Research Institute within a Health System or AMC | Vireon Global | 1036 | FY2024 | |
| Physician Practice Group | Clymera Networks | 1037 | FY2023 | |
| Physician Practice Group | Orbanta Systems | 1043 | FY2024 | |
| Matrix Cancer Center (within an AMC) | Tesserix Media | 1051 | FY2024 | |
| Matrix Cancer Center (within an AMC) | Kynetic Edge | 1052 | FY2024 | |
| Standalone Research Institute | Zyphra Holdings | 1053 | FY2024 | |
| Standalone Research Institute | Noventrix Inc | 1058 | ||
| Standalone Cancer Center | Stratigen Labs | 1063 | FY2024 | |
| Ecliptica Group | 1071 | FY2022 | ||
| Hospital / Health System | Maventra Solutions | 1305 | FY2025 | |
| Hospital / Health System | Xentara Technologies | 1332 | FY2025 | |
| Hospital / Health System | Bravion Enterprises | 1361 | FY2024 |
data :
| question | id | optionString | headerString | responseString | responseCount | institution_name | institution_code | year | Org Type |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 100 | Zentara Labs | 1332 | FY2025 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 150 | Corevia Health | 1305 | FY2025 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 150 | Lumora Analytics | 1058 | Research Institute within a Health System or AMC | ||
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 30 | Trivanta Group | 1022 | Matrix Cancer Center (within an AMC) | ||
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 40 | Omnexis Corp | 1037 | FY2023 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 400 | Fintara Ventures | 1010 | FY2021 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 400 | Solvexon Ltd | 1010 | FY2023 | Physician Practice Group | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 400 | Auralis Dynamics | 1027 | FY2021 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Federal (including National Clinical Trials Network) | Federal (including National Clinical Trials Network) | 700 | Hexora Biotech | 1010 | FY2022 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 10 | Vireon Global | 1305 | FY2025 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 200 | Orbanta Systems | 1027 | FY2021 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 25 | Tesserix Media | 1037 | FY2023 | Physician Practice Group | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 280 | Kynetic Edge | 1010 | FY2022 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 300 | Zyphra Holdings | 1010 | FY2021 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 300 | Noventrix Inc | 1010 | FY2023 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 40 | Stratigen Labs | 1022 | Physician Practice Group | ||
| Please provide the number of active studies by sponsor type | 2 | Foundation / Non-Profit | Foundation / Non-Profit | 60 | Ecliptica Group | 1058 | Research Institute within a Health System or AMC | ||
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 100 | Maventra Solutions | 1010 | FY2021 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 100 | Xentara Technologies | 1010 | FY2023 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 200 | Nexora Technologies | 1305 | FY2025 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 30 | Quantix Systems | 1022 | Physician Practice Group | ||
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 50 | Veltrix Innovations | 1037 | FY2023 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 500 | Zentara Labs | 1027 | FY2021 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Industry | Industry | 750 | Corevia Health | 1332 | FY2025 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Institutional | Institutional | 0 | Lumora Analytics | 1305 | FY2025 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Institutional | Institutional | 100 | Trivanta Group | 1010 | FY2022 | Matrix Cancer Center (within an AMC) | |
| Please provide the number of active studies by sponsor type | 2 | Institutional | Institutional | 100 | Omnexis Corp | 1058 | Research Institute within a Health System or AMC | ||
| Please provide the number of active studies by sponsor type | 2 | Institutional | Institutional | 30 | Fintara Ventures | 1037 | FY2023 | Research Institute within a Health System or AMC | |
| Please provide the number of active studies by sponsor type | 2 | Institutional | Institutional | 400 | Solvexon Ltd | 1027 | FY2021 | Physician Practice Group |
Hi esingh,
I Have replicated your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.
Regards,
Harshitha.
Hi esingh,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.