Sort Month Text in multiple year

In Power BI, in some specific contexts I wish I could make a report using trend chart showing values over 12 months, from jan to dec and comparing the trend of more years at the same time.

However, it’s impossible sort data by two helper column (monthsort) as there are more distinct values in the sort column than the result column.

The solution is very easy: Continua a leggere

Annunci

Power BI Diagnostics, Trace Logs And Query Execution Times (Again)

Chris Webb's BI Blog

I’ve blogged a few times now about how to monitor Power BI query execution times, most recently here, and while using functions like DateTime.FixedLocalNow() is all very well I’ve never been happy with the fact that you have to alter your queries in order to be able to time them. Using the Power BI trace logs always seemed a much better option – and since the log files are in a reasonably easy to understand text format, you can use a Power BI query to load data from them. I wrote a post on importing data from the trace logs (using Power Query) here back in 2014 and Rui Romano has a great post on doing the same thing for Power BI here. The big problem with the Power BI trace logs, though, is that there is too much information in them: they’re really meant for Microsoft internal…

View original post 980 altre parole