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.
Hi
I want the stacked colomun charts to show only TOPN values when NOT FILTERED by other charts or Slicers.
But when its filtered by other charts or slicers, I want the chart to show the filtered values in stacked colomun chart. Any help on how to resolve this on DAX?
I don't know which filters / slicers you have, but maybe you can try to catch the selectedvalue. I mean, imagine you have a date filter:
var dateSelected= SELECTEDVALUE(Calendar[Date])
return IF(dateSelected="", TOPN, measure)
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |