The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Using the Google Analytics connector again.
let Source = GoogleAnalytics.Accounts(), #"Account" = Source{[Id="xxx"]}[Data], #"Site" = #"Account"{[Id="yyy"]}[Data], #"View" = #"Site"{[Id="zzz"]}[Data], #"Added Items" = Cube.Transform(#"View", { {Cube.AddAndExpandDimensionColumn, "ga:yearMonth", {"ga:yearMonth"}, {"Month of Year"}}, {Cube.AddMeasureColumn, "Pageviews", "ga:pageviews"}, {Cube.AddMeasureColumn, "Avg. Time on Page", "ga:avgTimeOnPage"}, {Cube.AddMeasureColumn, "Entrances", "ga:entrances"}, {Cube.AddMeasureColumn, "Unique Pageviews", "ga:uniquePageviews"} } ), #"Filtered Rows" = Table.SelectRows(#"Added Items", each [Month of Year] = "201605"), #"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"Unique Pageviews", Order.Descending}, {"Pageviews", Order.Descending}}) in #"Sorted Rows"
the resulting table still has a row for every month. Power BI bug I assume?
Interestingly, if I add
{Cube.AddAndExpandDimensionColumn, "ga:pagePath", {"ga:pagePath"}, {"Page"}},
Then the filtering does work. So this is a strange bug.
@intrasight, I already reported your issue internally, will post here for any updates.
@intrasight, could you please help to provide one .pbix file with which we can quickly reproduce your issue?
@intrasight, we fixed this issue, it should be available to you in the release that will be around the end of September.
Thanks for reporting this to us!