403 questions
0
votes
0
answers
55
views
How to make a TEXT SLICER return the exact match instead of a search?
Originally TEXT SLICER is executing a SEARCH function so if user provides the first name and the column contains email addresses it will show all the email addresses with this first name. I am looking ...
0
votes
1
answer
69
views
How can I create a multi-slice slicer in Power BI?
I have created 2 tables:
table1 = GENERATESERIES(1, 10, 1)
table2 = GENERATESERIES(2, 20, 2)
I want them to appear using the same Slicer visualisation such that:
I have tried:
Table = DISTINCT(UNION(...
- 67
0
votes
0
answers
32
views
Custom last 4 periods DAX calculation issue
I'm trying to create a DAX measure in Power BI that calculates the average total number of issues per category across the last 4 custom periods (Versions) which happen irregularly.
I managed to ...
- 9
0
votes
1
answer
64
views
Power BI DAX: Show Selected Scenario While Always Displaying Baseline (Blank) Rows
In PowerBi, I have a table called Events and a ScenarioSlicerTable. I want the user to be able choose which Scenario to display, but I also want to always display rows where Scenario is blank. These ...
- 538
0
votes
0
answers
26
views
Date Slicer not working with custom DAX measure
I've created a custom DAX measure in Excel (not PowerBI) that returns the top 5 products and sums up the rest as "others", based on a tutorial I found online. Now when I apply a date slicer ...
- 11
0
votes
0
answers
25
views
Need difference of column filters based on slicer range selection by user
I have tables -> calender , bi_alloceffort_data & bi_alloceffort_data_main. I Have linked calendar date column to REVDATE column of bi_alloceffort_data & "PROJECTNO" of both the ...
-1
votes
1
answer
194
views
How to filter PowerBi table based on multiselect slicer - combination of selected slicer values
have this setup
Table1: Customers - Column: CustomerId, Name
Table2: Products - Column: ProductId, Name
Table3: CustomerProduct - Column: ProductsId, CustomersId
Relationship: 1-to-many between ...
- 25
0
votes
0
answers
97
views
Change filtering from one slicer to another Power BI
it's been awhile since I've reached out to your collective wisdom. Hopefully I format everything correctly.
I've got the following DAX formula for my second slicer, but the filter is not applying to ...
0
votes
1
answer
51
views
Return the number of objects in a slicer from another workbook
I am simply trying to get the number of objects in a slicer from another workbook.
Let's suppose I'm working on excel's workbook A.
I'm using the following code :
Sub slicerCount()
Dim wb As Workbook
...
- 3
0
votes
2
answers
214
views
Is it possible for a slicer to default to the current month?
Need to have a dashboards modified to have all Time Slicers (month. pay period) automatically default to the latest month. This will eliminate the need to manually update and republish reports with ...
0
votes
1
answer
49
views
Power BI dashboard with slicers that are additive and can recognize individual cell contents
I’m working on a Power BI dashboard and need help with setting up slicers to filter my data effectively. Here's the situation:
I have a table with columns for Primary Responsibility and Secondary ...
- 1
0
votes
1
answer
90
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
1
vote
1
answer
124
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
2
votes
1
answer
85
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
1
answer
59
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
480
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
1
answer
61
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. ...
1
vote
1
answer
847
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
1
vote
1
answer
52
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
1
answer
344
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 ...
2
votes
1
answer
44
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
790
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
1
vote
1
answer
65
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,...
- 412
0
votes
1
answer
268
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
182
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