Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dynamic column inputs to visualisations

Hi All, 

 

I've seen how to dynamically display different measures but I'm in need of returning a column of values instead. 


Essentially I have an extremely large database with several hundred columns that I will be connected to with Direct Query. I need to create a dashboard which provides a column summary of descriptive statistics which is easy enough with the dynamic measures using an additional table and the switch formula. However I require some charts such as histograms and pie charts which need to dynamically pass the column in to them rather than a calculated measure. 

 

For instance for the numeric columns I'll need the histogram to show the distribution and update based on the column selected. Or for categorical variables a pie chart to update to show parts of a whole. 


Does anybody have any idea how to do this? 

 

Thanks

3 REPLIES 3
v-cherch-msft
Employee
Employee

Hi @Anonymous 

Please check if below posts could help.

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks for the response @v-cherch-msft .

 

I'm not sure this is entirely the solution I'm looking for as it maintains the dependent variable and just changes how it is sliced. What I'm aiming to do is completely change the dependent variable that is displayed. 

 

For example imagine I have a histogram to plot the distribution of a variable (column) and then wanted to change the variable/column displayed in the histogram. 

Hi @Anonymous 

Not fully understand it.Please check if below post could help.

https://community.powerbi.com/t5/Desktop/Slicer-and-switch-selection/m-p/630595#M301460

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.