

Brisbane, 4000 QLD



+61 4 3836 7017

  • Follow
  • Follow
  • Home
  • About
  • Services
  • Power BI Gallery
  • Blog
  • Home
  • About
  • Services
  • Power BI Gallery
  • Blog

TOPN metrics in a parent child hierarchy

by Abhijith DSouza | Nov 20, 2021 | Power BI

Filtering a visual in Power BI by TOPN or BOTTOMN is very easy. You apply a visual level filter and specifiy how many TOP/BOTTOM values you wan to see in your visual. Things get complicated however when there is a hierarchy present in the visual.The TOPN filter will...

Recent Posts

  • Importing comments from Databricks Unity Catalog to Power BI
  • Musings from developing and deploying enterprise grade semantic models – Part 3: Technical learnings
  • Musings from developing and deploying enterprise grade semantic models – Part 2: General learnings
  • Musings from developing and deploying enterprise grade semantic models – Part 1: Introduction
  • How to solve business problems using DAX – Part 5: What is Australia’s share of global export coal revenue ?

Tags

Bookmarks Brisbane Calculation Groups Coal Mining Coal Qualities Conditional Formatting Daily sales Dashboard databricks Data Storytelling Date Interval DAX Disconnected tables End Users Enterprise Semantic Model Executive Dashboard FBI Heatmap ICE labels line and column chart Page Destination Page Navigation Parent Child Hierarchy Peabody Power BI Purpose ROI Rolling Average Selective Colouring Semantic Layer Seven Principles of DAX Management Solve Business Problems Speed Cameras SQL Stacked column chart Strategic Colouring Survey Temperature Top 10 TOPN Trend Trends UI/UX YTD

We bring analytics to your fingertips

  • Follow
  • Follow

Services

E

Data Modelling

E

Scripting

E

Visualisation & Reporting

E

Analytics & Insights

Contact

Address : Brisbane, 4000 QLD

Phone : +61 4 3836 7017
Capstone Analystics © 2020. All Rights Reserved.