Top N Filters in PBI Desktop Not Publishing to PBI Service

[TheoC]

HI all,

Apologies if this has been discussed elsewhere (I could not locate it).

Top N Filters working in Power BI Desktop on a Table visual (Top 10 based on x measure).  However, once published to Power BI Service, there are no filters resulting in the Table visual resulting in lots of values / records.

Has anyone experienced this and / or is there a resolution?

Thanks heaps!

TC

[v-janeyg-msft · Accepted solution]

Hi, @TheoC 

According to your description, I tested it and didn't find any problems. Did you forget to click apply or save?

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-janeyg-msft · Accepted solution]

Hi, @TheoC 

According to your description, I tested it and didn't find any problems. Did you forget to click apply or save?

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TheoC · Accepted solution]

Hi Janey,

Really weird however a couple of days after postingthe issue, it ended up being corrected.  I did refresh several times on the day and the next couple (even logged in / out of the browser and used private mode) but it wasn't until the third day that the issue fixed (along with another reoccurring, but separate, glitch). 

I am unsure what the cause was, however, it seems to have been fixed now.

Thanks heaps for responding and for following this up! 🙂

[TheoC]

Just following on from the above, I have noticed that the "Top N" filter is published in Power BI Service where the filter does not use a DAX Measure as the basis of the filtering.  In the above instance, the filter does not transfer to to Power BI Service where a DAX Measure is used as the "By Value" for "Top N" filters.