Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Say I have slicer that is using values from 1-15 in steps of 5, these values are being used to make a TOPN measurement, I have, dynamic, as seen in the SELECTEDVALUE function below.
TopCustomer =
VAR PickFromSlicer = SELECTEDVALUE('TOPN Selection'[TOPN Value])
RETURN
SUMX(
TOPN(
PickFromSlicer,
FILTER(ADDCOLUMNS(
VALUES(YourTable[Customer]),
"Total",CALCULATE(COUNTROWS(YourTable)),
"Rank", RANKX(ALL(YourTable[Customer]),CALCULATE(COUNT(YourTable[Customer])))
),[Rank] <= PickFromSlicer),[Total],DESC),[Total]
)I want my slicer selections to be text as listed in the below table, but I still need the numeric value to be used in my TOPN measurement.
| TOPN Value | Text to be shown in Slicer |
| 5 | Very Narrow View |
| 10 | Narrow View |
| 15 | All |
Has any one done something like this before? Is it possible?
Solved! Go to Solution.
After some expierimenting, I figured it out! By adding the "Slicer Text" Column to my slicer table, by right clicking on it and clicking "Edit Query" in the drop down, making my changes(adding the column) and then pressing "Close and Apply," a feild with my new column name appeared in the Feilds Pane. I then clicked on my slicer, and unchecked the "TopN Value" feild(under my slicer table) and then checked the "Slicer Text" feild. I am newer to Powerbi, so this was not obvius to me. I hope this discription helps someone in the future.
After some expierimenting, I figured it out! By adding the "Slicer Text" Column to my slicer table, by right clicking on it and clicking "Edit Query" in the drop down, making my changes(adding the column) and then pressing "Close and Apply," a feild with my new column name appeared in the Feilds Pane. I then clicked on my slicer, and unchecked the "TopN Value" feild(under my slicer table) and then checked the "Slicer Text" feild. I am newer to Powerbi, so this was not obvius to me. I hope this discription helps someone in the future.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |