Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have a direct query to my data set yet I need the follwoing:
When there is no value selected in the slicer for example when there is no date selected or there is no customer number selected then my table should rest in null and only show values if the user selects a date and a customer number.
Thanks
Solved! Go to Solution.
Assuming you have a date slicer and a customer number slicer, and you want your table to show values only when both a date and a customer number are selected, you can create a measure that checks if the slicers have selections and then display the values accordingly.
Here's an example of how you might structure your DAX measure:
YourMeasure =
IF (
ISFILTERED('DateTable'[DateColumn]) && ISFILTERED('CustomerTable'[CustomerNumberColumn]),
-- Show your values here when both slicers are selected
SUM('YourDataTable'[YourValueColumn]),
-- Show null when either or both slicers are not selected
BLANK()
)
In this example:
This DAX measure checks if both slicers are filtered (ISFILTERED function) and, if so, displays the sum of your values; otherwise, it displays BLANK().
You can adjust this DAX code based on your specific data model and column names. Remember to replace the placeholder table and column names with your actual table and column names.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
Assuming you have a date slicer and a customer number slicer, and you want your table to show values only when both a date and a customer number are selected, you can create a measure that checks if the slicers have selections and then display the values accordingly.
Here's an example of how you might structure your DAX measure:
YourMeasure =
IF (
ISFILTERED('DateTable'[DateColumn]) && ISFILTERED('CustomerTable'[CustomerNumberColumn]),
-- Show your values here when both slicers are selected
SUM('YourDataTable'[YourValueColumn]),
-- Show null when either or both slicers are not selected
BLANK()
)
In this example:
This DAX measure checks if both slicers are filtered (ISFILTERED function) and, if so, displays the sum of your values; otherwise, it displays BLANK().
You can adjust this DAX code based on your specific data model and column names. Remember to replace the placeholder table and column names with your actual table and column names.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
9 |