Forum Discussion
create dynamic axis based on two slicers
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.
Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.
Need help uploading data? click here
Want faster answers? click here
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.