407 questions
0
votes
1
answer
37
views
DAX Dynamic Measure as a Slicer in Power BI
I am trying to create a slicer in Power BI. This slicer is based on the selected value. As a result I want to get the results of 'WeekFilter' as my Slicer. But unfortunately Power BI won't let me, ...
- 81
0
votes
0
answers
14
views
Slicer filter on embedded power bi by API
In my embedded power bi report I'm using a component name Smart Filter pro by OKVIZ. I want to select some items using filters by javascript. I tried according to their documentation but its not ...
- 126
0
votes
1
answer
23
views
How to make Slicer Work on Inactive Relationship in PowerBI?
I’m working on a Power BI model with the following relationships:
DimManager is connected to DimProjects through a direct relationship (via ManagerID).
DimProjects contains project-level details and ...
0
votes
0
answers
35
views
Create a dynamic DAX table where at least one slicer applies
I have a report where my stakeholders want to know the distinct count of a individual_id based on if ANY slicers apply, rather than if ALL filters apply which is default PowerBI filter behaviour.
I've ...
- 314
1
vote
1
answer
72
views
Issue with PivotTables when running VBA Code to Loop through Slicers and Print to and Save PDFs - Couldn't Complete Action Because Theres Already
I tried to find a previous QA on this, but I haven't been able to find a solution.
I have inherited a connected Excel spreadsheet that has one worksheet that contains a slicer with about 170 different ...
- 61
0
votes
0
answers
57
views
Power BI/DAX: dynamically filter table values with slicer
I have a Power BI table visual with a column "Monthly Report" containing text values such as "2024 08 August" "2024 09 September", etc...
There is an associated column &...
- 13
0
votes
0
answers
40
views
Calculate Year-over-Year Difference with User-Selected Reference and Comparison Years Using Slicers
"How can I create a measure in Power BI to calculate the difference (%) between two selected years, where the user can choose both the reference year and the comparison year from slicers on the ...
0
votes
1
answer
68
views
Power BI Slicer options settings
In Power BI, I have three slicers: Slicer 1, Slicer 2, and Slicer 3. Slicer 1 acts as the primary slicer, with two options labeled "program" and "non-program." Meanwhile, Slicer 2 ...
- 1
2
votes
1
answer
63
views
Sum of Value between Slicer Dates
I want to get the sum between two slicer dates without breaking it out by month. The number should be static for the dates selected.
Here's an example of the data I'm trying to get information from:
...
0
votes
0
answers
29
views
Power BI - Get slicers to mirror data from the same period of the previous selected year
I have a table visual containing the individual quatation entries made by each broker.
Firstly, I wanted it to display the data from the same period of the previous year based on the selection made in ...
- 49
0
votes
0
answers
41
views
How to use a selected slicer value to do a calculation on it and use this calculation result to filter a pivot table
I need to use two filters, YEAR and YEAR-1 values, on two distinct pivot tables. The YEAR value is selected from a slicer, for instance, 2024 and then, the first pivot table connected to this slicer ...
0
votes
0
answers
27
views
Power BI current week information only on visual - does not change due to slicers
I am trying to create a measure that feeds the visual, however I cannot get it to just look at current week or last week without being affected by slicers.
Here is the code so far:
VAR CurrentWeek = ...
0
votes
0
answers
38
views
Power BI Date Table Slicer Returning Blank Visualizations
I am trying to create a date slicer with the date dimension table that will reduce records/count of records in a visualization based on the dates selected by the user. The date dimension table has an ...
0
votes
0
answers
61
views
M Query parameters aren't connecting to my data slicers! Bind to Parameter?
I've spent a couple hours on a project today and I'm getting stuck on creating some date slicers for a Power Query I have in DirectQuery mode. I've seen a few people run into this but without a ...
0
votes
1
answer
51
views
Use slicer to dynamically select column
How can I use a slicer to dynamically select a column from my table? I want to have two slicers: the first to select the function and the second to select the column. I can get the first slicer ...
- 538
-1
votes
1
answer
23
views
Powerpivot with slicer on two tables [closed]
Trying to learn PowerPivot and slicers using two simple tables.
Titles:
Media:
The tables are linked by ID
I created a pivot table listing the Titles > title field and a slicer based on the ...
- 497
0
votes
0
answers
35
views
Creating a new slicer in Excel duplicates an existing slicer connected to another pivot chart
I have an Excel file containing many pivot charts with slicers connected to each chart.
I have noticed that when I create a new pivot chart by duplicating an earlier one (ie: by copying an earlier ...
- 2,492
0
votes
1
answer
29
views
Using OR condition between >2 slicers, and slicing even if not all slicers are active
I want to be able to filter my visuals based on whether any of my multiple slicers are active.
I have been able to display data fitting any of the values in my slicers (rather than all of them) using ...
- 314
0
votes
0
answers
26
views
How to fix slicer position in excel during cell scrolling in any direction
In excel when i scroll cell in any direction that time slicer position also be scroll in cell direction but i want to fix slicer position for any scrolling it remain fix at their position
I try to fix ...
0
votes
1
answer
194
views
How to use Measure as Slicer in Power BI
I have a measure, i want to filter it with a slicer with under stock, over stock In 'Table' visual , optimum , how to do it in Power BI
StockStatus =
VAR Department = SELECTEDVALUE('3_month_sales_&...
0
votes
0
answers
24
views
Dynamic MTD and YTD slicer using YTD Data
I have provided the image of the sample data where I have YTD data (Actual, Plan, Prior Year) by period for a city. I already have a slicer with periods.
Suppose I select Period 6 in the period slicer,...
- 1
0
votes
2
answers
47
views
Is it possible to insert a slicer before the vba code runs?
I have created a vba code which copies data from the main sheet to a new sheet depending on a specific cell "Status". If Status is set to active then that particular row is copied and pasted ...
- 13
0
votes
0
answers
41
views
Is there any way to update caption of excel's Slicers using c# code for spire.xls
Is there any way to update caption of excelsheet's Slicers using c# code for spire.xls
I have tried some part of code googled through internet but it was only for PivotTables and not for the Slicers. ...
0
votes
0
answers
23
views
Distinct count from multiple tables and slicers
To create a gap analysis, I want to create a customer-specific table or matrix, showing products for a given customer, and a second one showing all products available in that country.
We have the ...
- 1
0
votes
0
answers
77
views
Multiple Slicers with Multiple Selection in each with AND condition in Power Bi
I am working on a model that filters items based on the criteria given in the slicers. In this I want to filter the item through three slicers
Hierarchy Slicer
Attribute Slicer
Attribute Value Slicer....
0
votes
0
answers
87
views
Macro to work through list of slicer options and print the sheet to PDF
I have an excel dashboard, the data within which is based off what country the user selects from a 'Geography' slicer. This code previously worked fine in another workbook, but now that I have copied ...
0
votes
0
answers
129
views
How to See / Generate a List ALL Slicers Attached To / Controlling a Excel Pivot Table
In Excel I can go to a specific SLICER, right click, select Report Connects, and see a list of all PIVOT TABLES in my Excel workbook with checkboxes to identify the subset of PIVOT TABLES that are ...
0
votes
0
answers
42
views
PowerBI DAX - Using the result of SELECTEDVALUE() in the FILTER() Function
I have the following code to create a new Table in PowerBI based on a condition:
VAR Auswahl = SELECTEDVALUE('Y-Achse-Langzeit'[Parameter])
VAR Tabelle = ADDCOLUMNS(
'Daten Langzeitanalyse',
...
- 21
1
vote
1
answer
344
views
Power BI: Automatically set "Between" Data Slicer to Current Data
when opening my report user-confusion may arise from the fact that a date slicer is not automatically extended to the current date of data available.
My question therefore is:
Does anyone know a ...
- 31
0
votes
1
answer
115
views
Selecting most recent date in slicer
I need to select the most recent date slicer dynamically in this specific tab. My current code selects all of the dates listed in the slicer.
Sub maxdateslicer()
Sheets("FIP").Select
...
- 3
0
votes
0
answers
216
views
How can I get a current year vs prior year comparison in dax using selectedvalue and a month and year slicer?
The measure I created works fine for current year no matter what year and month I select. However, the prior year measure has missing values in some locations. The values should be there because they ...
- 1
0
votes
0
answers
29
views
Dynamic Line Chart with Selection and Its Higher L1 & L2 Categories
Thanks to anyone who takes a look.
I've been frustrated for a few days, trying many ways and checking numerous posts, parameter (not working).
Model Detail:
I'm working with a 3-tiered data model and ...
- 1
1
vote
1
answer
45
views
Calculation based on 2 Years selected from slicers
I'm still new with Power BI Desktop and I have one scenario where I have current and previous years as two slicers which user should select. and based on that the calculation should be subtraction of ...
- 21
0
votes
0
answers
44
views
How to have default slicer selection based on another slicer
I have two slicers, Month and Week. The Week slicer filters the Month slicer, so whenever I choose a week, it filters to that corresponding month.
There's my question, is there a way when I choose a ...
- 1
0
votes
0
answers
41
views
Powershell Pivot Tables Slicers not linked even though using same data source
Using powershell I have created multiple pivot tables in the same Excel worksheet using the same table at the Data Source.
I then open the excel file and add a slicer to one of these Pivot Tables and ...
- 189
0
votes
1
answer
207
views
Power BI slicer dropdown with array values
I want to create a slicer for availableDataTypes field. I have array of values in availableDataTypes field.In the dropdown I want only [1],[2],[3] & none Options
It should be a multiselect ...
0
votes
0
answers
24
views
2 Slicer in same Power BI dashboard is not working properly
In my dashboard There is a matrix. In that first column is product. And the rest of the columns are Week1, Week2, Week3 upto week 52. Values in these columns are price of products in each week.
I need ...
0
votes
0
answers
209
views
"Preselected Slicer" Custom Visual, Pre-Selection Measure
What should I be giving the Pre Selection field in order to have a certain value selected by default on load in my slicer?
I've tried a LOOKUPVALUE statement that yielded the matching string, and I've ...
- 1
-1
votes
1
answer
127
views
VBA to change selection on a Power Query Table Slicer
I have been stuck on this all day and would really appreciate some help.
I have a table which I created in Power Query and have loaded this into an Excel worksheet named "Pay Com". To this ...
- 1
2
votes
1
answer
43
views
Facing Compare Issue in powerBI
I am trying to compare the response time to two releases of the product. But when I trying to create the comparison table, I am facing issue. In the below picture 1 you can see that, both release ...
- 172
0
votes
0
answers
58
views
Power BI Percent of Total but not Top N
I am trying to calculate the percentage of premium which should change as I apply slicers on the data. The below formula for a calculated measure works perfectly.
% of 2025P Gross EP = DIVIDE(SUM('...
0
votes
1
answer
197
views
PowerBI Slicer to filter column headers
I'm trying to have a slicer that uses certain column headers as a filter. The visuals are using a measure that is calculated from the "NPS Response" column, and I haven't been able to get ...
- 1
0
votes
0
answers
471
views
How to create pivot table of a pivot table OR add a pivot table into Power Pivot
I created a dashboard sourcing the data through Pivot tables generated with a Data model.
The challenge I have at the moment is to get a slicer that shows the actual values of the pivot table (not a ...
- 1
0
votes
0
answers
64
views
How to sync selection from a "Attribute Slicer" to another page of same report
in the page 1 of my report, I have two slicers as below. One is Practice name slicer, the other is Project name. Selection of practice filters out the project name slicer. Based on the selection from ...
- 1,307
0
votes
2
answers
761
views
PowerBI: How to remove filter on specific column in chart
I'm working with specific columns from a table. I have a "data" column for each month of the year and a "data_last_month" column for December + percentages. I have a chart filtered ...
1
vote
1
answer
55
views
How to take last data available based on the slicer?
I got a request for a visual to take the last data available based on the slicer.
We have year, quarter and month slicers in the report.
If multiple months are selected, there will be no summarization,...
- 414
0
votes
1
answer
117
views
Using a single slicer to dynamically filter multiple pivottables from excel data model
I have a project for which I am creating a dashboard. In this dashboard I have multiple pivotcharts that use slicers connected to all pivotcharts to filter and visualize data. This works great when ...
0
votes
1
answer
219
views
Categorizing category name based on date range and slicer selection in Power BI
I have the following datasets:
DatasetL
I wanted to write DAX code in which I haven't found the right logics for the following case below:
The table of datasets above represent Subject Table with ...
- 1
0
votes
1
answer
244
views
How to make a default values
I have county names as dublin1, dublin2, dublin3 how to make a single default name as dublin to those values in power bi?
I have tried to remove duplicates but it is not a correct solution. I have ...
- 3
0
votes
1
answer
128
views
Power Bi, diference between 2 sliced cards
Power Bi desktop,
How can I display in a card the difference between 2 cards which are sliced each one by months?
I have a measure displayed 2 times. Each measure is sliced by 2 different slicers (the ...
- 13