Forum Discussion
Help Needed in Nested Sorting for Hierarchical Bar Chart
yes, This is what I'm looking for. Could you please share the steps which you followed. Thanks in Advance.
Super UserThank you. Its working for me. I do have one more query in the same DAX, on the same bar chart, I have visual level measure filter which restricts the data for sales >=1.
The abpve dax is working without the filter, but if I add that visual level filters, the sort s not working properly. I know we have to add that filter somewhere inside the m2 calculation summarization part.
Could you please help me with that as well ? Appreciate your help and time.
- Ahmedx
I don’t understand, please share the file with the problem
Scenario : Need to show subcategories which having Sales more than 50.
Problem : When I apply visual level filter, its resetting the sort.
PBI file : Sample PBI File - Filter Interfere with Sort
- Ahmedx
if you find that you have a lot of subcategories and because of this the measure is violated, then try this measure
You can replace 100 with 1000 if you have a lot of subcategories
clarainesggHelper I
Hi, I have the same Issue. I can open the bar graph dashboard. Could you send in another version? Thanks!
- clarainesgg
Hi, I am following the steps and i got an error:
Failed to resolve name 'ROWNUMBER'. It is not a valid table, variable, or function name.