Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an aging table.
My data is like this:
Customer | Aging | Amounts |
Apple | Not Due Yet | 4.000.000 |
Apple | 1-30 days | 1.500.000 |
Apple | 31-60 days | 300.000 |
Apple | 61-90 days | 200.000 |
Microsoft | Not Due Yet | 50.000 |
Microsoft | 1-30 days | 500.000 |
Microsoft | 31-60 days | 200.000 |
Microsoft | 61-90 days | 100.000 |
1-30 days | 600.000 | |
31-60 days | 700.000 | |
61-90 days | 400.000 |
I have a measure to calculate the
Overdue = CALCULATE(SUM('CustomerAging'[Amounts]),'CustomerAging'[Aging]<>"Not Due Yet")
I want to create slicers/buttons so the user can choose to show aging of customer with certain conditions:
Overdue > 2.000.000
Overdue > 1.000.000
Overdue > 500.000
If i use the filter in the report and filter the visual by Overdue is greater than 1 000 000 it works perfectly.
I created a measure like this:
Customer | Aging | Amounts |
Apple | 1-30 days | 1.500.000 |
Hi @MegaOctane1 ,
not sure if i fully get you, try like:
1) create a calculated table like below and plot a slicer accordingly:
Slicer =
SELECTCOLUMNS(
{500000, 1000000, 2000000},
"Overdue", [Value]
)
2) plot a card visual with a measure like:
OverdueOverSelection =
VAR _table =
ADDCOLUMNS(
VALUES(CustomerAging[Aging]),
"Amt",
CALCULATE(SUM(CustomerAging[Amounts]))
)
VAR _result =
SUMX(
FILTER(
_table,
[Amt] > SELECTEDVALUE(slicer[overdue])
&& CustomerAging[Aging]<>"Not Due Yet"
),
[Amt]
)
RETURN _result
it worked like:
Sorry, I have corrected the Overdue measure.
The correct DAX formula:
Overdue = CALCULATE(SUM('CustomerAging'[Amounts]),FILTER(CustomerAging,CustomerAging[Aging] <> "Not Due Yet"))
I have created three matrix tables to show what i want to get out of this "slicer filter".
How can i get the result without filtering the visual in the filter pane?
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |