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'm Newbie to PowerBI
I'm facing an issue while getting the drill down.+
Below Image is my landing screen.
For next level of drill down I'm going to select "Before and After School" in the Y axis.
In my drill down it would be "Yearly, Quarterly, Monthly". So while in drill down the name of the Workarea has been not visible.
Is there any possible way to show the Name("Before and After School) in Y axis?
Thanks in advance 🙂
Regards,
Prathap S
Solved! Go to Solution.
You should be able to write a measure using HASONFILTER and probably VALUES on the field at the highest level of your hierarchy and display it using a card visualization above or to the right of your bar chart. Perhaps something like:
IF (HASONEFILTER([field]),VALUES([field]),"")
something along those lines.
Have you tried the forked double arrow?
Yes, I tried Folk double arrow but it doesn't meet my requirement. Is it possible to have a Text object(i.e Qlikview have this functionality) where i can write some expression to bring the data. is there any functionality available in Power BI ?
Thanks,
Prathap S
You should be able to write a measure using HASONFILTER and probably VALUES on the field at the highest level of your hierarchy and display it using a card visualization above or to the right of your bar chart. Perhaps something like:
IF (HASONEFILTER([field]),VALUES([field]),"")
something along those lines.
Hi smoupre,
Cool your expression works fine for one of my requirement. Really grateful.
But if I turn on the Drill down icon and after clicking the chart
I selected the Bar of "Kindergarten" but drill down to next "Year-Wise" after then "Quarter-wise" but you can see the Lable Name has been changed to my default value which gave.
While drilling down also "Kindergarten" to display while selecting the drill down option.
Could you please assist me in this.
Thanks,
Prathap S
Hmm, how about something like:
IF (HASONEFILTER([field]),VALUES([field]),IF(HASONEFILTER([quarter]),VALUES([quarter]),""))
Just next repeatedly for as many levels in your hierarchy.
Thanks for your response.
I'm a newbie to powerBI just now started to work. It would be great if you help me out this thing.
It would be great if you share any sample/ Document regarding this. Or any tutorial video url
Thanks,
Prathap S
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |