Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have requirement to show top 15 records and rest all other records to Show as Others,
I have one Employee ID's column and one calculated colum- Total Efforts spent
I have to show top 15 Employees with total efforts spent and rest all Other employees to show as "Others" in Table Chart.
Any help?
Thanks
Likhitha
Thanks
Solved! Go to Solution.
Hi @Anonymous
You can refer to the following example
create a new column in the table
Type = var _top15=SUMMARIZE(TOPN(15,'Table',[Total],DESC),[ID])
return IF([ID] in _top15,FORMAT([ID],""),"Ohter")
Then put the column to the table visual, and create a new measure in the table
Measure 2 = SUM('Table'[Total])
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can refer to the following example
create a new column in the table
Type = var _top15=SUMMARIZE(TOPN(15,'Table',[Total],DESC),[ID])
return IF([ID] in _top15,FORMAT([ID],""),"Ohter")
Then put the column to the table visual, and create a new measure in the table
Measure 2 = SUM('Table'[Total])
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Can you provides some sample data?
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |