Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Direct Query output using Slicer

I have below select statement in direct query mode and I have Column A as slicer. It looks like in power BI the results for below select statement is derived first and the slicer selection dataset is derived as final output. Which give a wrong output for the requirement as the E value is calculated overall before the slicer is applied. I want the E column to be calculated after the slicer is applied.

 

Select A,B,C,D,

SUM(D) Over(Partition by B,C) AS E from table

 

1 REPLY 1
dax
Community Support
Community Support

Hi PowerBIUser3004,

 

According to your description, it seems that you want to use slicer to control data which load in powerbi, right? As I know, the slicer only apply on existing data of report, it can't work conversely on datasource.

 

If you wnat to achieve this dynamically, I think you could try to use parameter in query. You could refer to Pass parameter to SQL Queries statement using Power BI for details.

 

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.