Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
95 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |