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.
I'm looking for a way to change messages based on different drill down levels in a bar chart. My hierarchy is Trade, Manager, Representative, State, Market, Vendor.
This is my DAX formula so far...
Selected = VAR Selected = FIRSTNONBLANK(Trade[Contrel Trade],TRUE) VAR selected_trade = FIRSTNONBLANK(Trade[Contrel Trade],TRUE)
VAR selected_Manager_Name = FIRSTNONBLANK('Contrel Manager'[MANAGER_NAME],TRUE)
VAR topvolumebyMarket =MAXX(SUMMARIZECOLUMNS(Dispatch[MANAGER_NAME],Dispatch[MARKET],
"MaxDispVolume",Dispatch[Disp Count]),[MaxDispVolume])
RETURN
IF(HASONEVALUE('Contrel Manager'[MANAGER_NAME]), selected_Manager_Name & "'s largest dispatch volume is in Market " & FORMAT(topvolumebyMarket,"###,0"),"PICK SOMETHING!!!")
The return statement works if I go to that layer in the chart, but I lose it if I use the 'Drill Down' feature. I can't seem to get any of the other layers to respond either. ANy help is greatly appreciated!!!
Drill down does not change filter context, so your measures won't update. I thought the standard headings auto updated during drill through
I'm not using standard headings...I'm using a card to call out specific information based on the drill down. Another words...it would be a dynamic card to say something based on selected State...the next level..I might change the message based on selected Manager...etc...
And as I said, drill down does not change filter context, so this approach is not going to work. But if you look at the standard headings I think you will find that they do work.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |