How to ignore a slicer for one measure, but apply it on another?

0 votes

I'm new to power bi and DAX, I am trying to deal with a graph where the X-axis shows the hours of the day. Each bar shows data of a specific location, yet it's possible that two different bars would show the same location because of a time difference (hours on the X-axis). What I'm trying to do is to SUM a column, grouped by location.

Any kind of help would be appreciated.

Oct 1 in Power BI by Roshni
• 6,030 points
219 views

1 answer to this question.

0 votes

In order to ignore Slicer you need to ignore the filter context created by that slicer. And to adjust/ignore Filter Context, you need to use the Calculate/Calculate table function.

answered Oct 1 by Gitika
• 48,800 points

Related Questions In Power BI

0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,200 points
1,316 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

answered Mar 1, 2019 in Power BI by Cherukuri
• 32,490 points
2,102 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,490 points
2,827 views
0 votes
1 answer

Can i show data for one variable for a field without using slicer?

Hi Pranav, Yes, you can perform the calculation ...READ MORE

answered May 16, 2019 in Power BI by Cherukuri
• 32,490 points
122 views
0 votes
1 answer

How to get month name from month number in Power BI?

You can use: MonthName = FORMAT(DATE(1, [Num], 1), ...READ MORE

answered Sep 24 in Power BI by Alisha
39 views
0 votes
1 answer

How do I use the DAX function ParallelPeriod?

The DAX expression you used in the ...READ MORE

answered Oct 5 in Power BI by Gitika
• 48,800 points
40 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

Create a new measure for the km ...READ MORE

answered Oct 5 in Power BI by Gitika
• 48,800 points
48 views
0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14 in Power BI by Gitika
• 48,800 points
53 views
0 votes
1 answer