- 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.
-
bematth
on: Copying Table with Filters is Ignoring Filters
- tbuck on: March 2025 Update - Error fetching data for this v...
- rschimmel on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- TwanVerdonschot on: Conditional Formatting - Field Value not working a...
- njf on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
-
v-xiaoyan-msft on: Card (new) - SVG images dont render correctly
- New 7,871
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,149 -
Data Modeling
4,093 -
Dashboards
4,082 -
Gateways
2,103 -
Report Server
2,099 -
APIS and Embedding
1,950 -
Custom Visuals
1,770 -
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.