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.
Hello All,
So I have a working solution for dynamic Column Series which is fed by a selection of a slicer and likewise, I have a dynamic selection for Column Values for a Stacked Bar chart. What I am trying to achieve is a dynamic Shared Axis too for Quarter and Month. I have two calculated columns -
For Quarter the values are - 2017-Q1, 2017-Q2 and so forth
For Month the values are - 2017- January, 2017-February and so forth
For my Dynamic Date Selection I created a Table with two Values - Quarterly and Monthly and I created another slicer for this and the final value that was to be dynamic for the Shared Axis is something like TIme Intelligence = SWITCH(SELECTEDVALUE('TIME TABLE'[TIME]),"QUARTERLY",VALUES('Main Table'[Quarterly Date]))
but this fails as the above measure returns more than one value which is what I want but it errors out. Is this possible to do?
Thank You
Solved! Go to Solution.
Hi @nirvana_moksh,
I'd like to suggest you take a look at following blog, it may suitable for your requirement:
Dynamic Attributes In A Power BI Report
Regards,
Xiaoxin Sheng
Hi @nirvana_moksh,
I'd like to suggest you take a look at following blog, it may suitable for your requirement:
Dynamic Attributes In A Power BI Report
Regards,
Xiaoxin Sheng
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |