Forum Discussion
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 want to build a visual where values from both filter can be passed into the bar chart. The visual axis should show Your Response and Institute 1, Institute 2, Institute 3, Institute 4 etc. based on the cohort filters. if the values selected in cohort are 20 we should get Institute 1, Institute 2, Institute 3, Institute 4..upto Institute 20 and Your response.
the green should say your response rest should be institution 1,2,3,,,, upto selection in cohort slicers.
is this achievable in power BI
Thanks
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.
7 Replies
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,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to FBergamaschi ,for those inputs on this thread.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Harshitha.
Hi esingh,
Just checking in to see if you had a chance to follow up on our earlier conversation. If you're still encountering the issue, please share the sample data so we can assist you with an accurate solution.
If you have any further questions, feel free to reach out anytime.
Best Regards,
Harshitha.Hi esingh,
Hope everything’s working fine now! If you have found a fix, feel free to share it. It really helps others in the community.
If we don’t hear from you soon, we’ll close this thread for now. But if you ever need help again, just start a new thread, we are always here to support you.
Best Regards,
Harshitha.
