create dynamic axis based on two slicers

[esingh]

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

[v-hjannapu]

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.
 

[v-hjannapu]

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.

[v-hjannapu]

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.

[FBergamaschi]

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

[esingh]

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

[v-hjannapu]

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.