Forum Discussion
Building a hierarchy
Thanks for your help. Maybe I'm not clever enough with Power BI at present.
I ended up writing a custom SQL which selected all the columns I needed along with renaming columns (I don't want two called CategoryName or any number called ID!) and using that to pull in the data rather than letting Power BI do it itself.
I can now drill down to the children of where I click so I'm happy. I'm also happy as it's probably pulling in less data (there are quite a few columns that are not needed), plus I understand SQL queries and it was easy to look at the results in SSMS to verify it's working correctly. I do have an SQL issue but I'm sure it can be resolved - I've used Informix for years and SQL Server is just slightly different... :)
Great to hear that, you could accept your reply as solution to close this thread. If you have any question, just feel free to post. :)
To explain a bit further, I found I can drill down without a hierarchy but only to all values in the level below, rather than to just the ones below the area or town I click on.