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.
I am having problems with filering out the top N in my report.
The table consists of page name, type (site page, news post or document) and unique viewers.
I am only interested in the performance of the top 3 news articles, so I have applied the following filters|
. Type is news post
. Type top 3 by sum of unique visitors
But unfortunately I am still being shown all of the articles in my table|
How to solve this?
BTW, this is the table|
Tx!
Solved! Go to Solution.
Hi @Anonymous ,
You are getting all values because of same sum values of unique visitors , (i.e. 1),
try top 2 you will only two values because of unique sum values.
Hi @Anonymous ,
You are getting all values because of same sum values of unique visitors , (i.e. 1),
try top 2 you will only two values because of unique sum values.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |