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, 2020 in Power BI by Roshni
• 10,420 points
1,176 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, 2020 by Gitika
• 65,870 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,688 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,910 points
2,468 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,910 points
3,790 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,910 points
142 views
0 votes
1 answer
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, 2020 in Power BI by Alisha
74 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, 2020 in Power BI by Gitika
• 65,870 points
84 views
0 votes
1 answer

DAX. Problem with subtotals and grand totals

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

answered Oct 5, 2020 in Power BI by Gitika
• 65,870 points
155 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, 2020 in Power BI by Gitika
• 65,870 points
86 views
0 votes
1 answer

How do I count rows in one table based on values in another table using DAX?

If the tables are related, this is ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,870 points
2,954 views