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. Creating these tables with formulas in Excel is easy but I want to create this in Power BI. All 3 of these columns are aggregates. And I am filtering out the top 15s using the last column. So I need both positive and negative values. How do I do this in Power BI?
Solved! Go to Solution.
Thanks for your replies everyone.
I was having the table aggregate values for me and that's why I could only use half of your solutions. So I created another column of those same aggregates and added that pre-calculated column to my table. And then I was able to turn that column into absolute values, and use that to filter TOPN.
I am marking this as closed now.
I might have misinterpreted your situation.
You could create a measure like below;
Measure = ABS(Values of last column)
Now you will only use the absolute values and thus negative and positive values. Use this measure to filter the top 15.
Use your regular values to show in the visual. Because the measure will show you the values in positive format.
Hi @Anonymous,
I am using aggregates to make my table. I tried the ABS solution but it wasn't working since the aggregates get messed up.
You need to TOPN filter a different calculation than your current comparison. You can make a calculation that converts the all diffs to positive. You dont have to display the calculation you use for filtering, so you can display your original and use the other for the filter.
Thanks for your replies everyone.
I was having the table aggregate values for me and that's why I could only use half of your solutions. So I created another column of those same aggregates and added that pre-calculated column to my table. And then I was able to turn that column into absolute values, and use that to filter TOPN.
I am marking this as closed now.
Did you use the measure in the table?
Hi @Anonymous ,
You can use 'data bars' under conditional formatting in the table visual to achieve this.
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |