- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Table Filter does not work based on slicer selection
Dear members,
could you please help on the below issue
i'd added a what-if parameter on a slicer and used it to filter line chart visula based on the slicer selection (measure is added to calculate Aging average dymanically for the values less than or equal selected slicer value):
where:
DP-M-Ag Excluded : a meausre
'R_DP_M_tbl'[DP-M Ag]: Aging column inside 'R_DP_M_tbl' table
AgingLimitDP : what-if parameter
it works fine, but when i tried to create a calculated table of excluded records "with aging values greated that slicer selected value" it doesn't work and there is no filtered applied , calculated table DAX as below:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-
smpa01 on: We couldn't load your datamart
- BecC on: Turned off Callout Values in Card (New) Visual sti...
- catsamson on: SVG Image URL in Card (New) Visual is not working ...
- marvindo on: New Card Visual inadvertently switching on values ...
- Heather_Schramm on: Copying Table with Filters is Ignoring Filters
- DNilsson on: March 2025 Update - Error fetching data for this v...
-
AnGanjam on: Snowflake connector isn't showing views after Marc...
-
mattlee on: March 2025 update - Style preset error
- Eder_JG on: Conditional Formatting - Field Value not working a...
- jbongjbong on: Stretched App's Logo in Home Page "Recommended"
- New 7,880
- Needs Info 3,502
- Investigating 3,603
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,154 -
Data Modeling
4,094 -
Dashboards
4,083 -
Gateways
2,103 -
Report Server
2,100 -
APIS and Embedding
1,951 -
Custom Visuals
1,772 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1
Hi,@Hosamby .Very happy to see that my advice has been of help to you.
Since the definition of the calculated table itself (which is static) doesn't support it changing dynamically according to the slicer, what we can achieve is to try to restore the output of the entire table through multiple measures (which is the step you're operating on).
Thank you for your support and understanding of power BI.