Only Coders

python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - slicers

Using one slicer (Date) with two different tables and two different data columns

I have several tables in my data model. Among others I have the table "Sales" (with all sold products by customer, date and marketing source) and the table "Media Spend" (with all...

Florian

powerbi

data-modeling

powerbi-desktop

relation

slicers

Votes: 0

Answers: 1

Latest Answer

You can create a dates table by selecting New Table when you're in Power BI as can be seen below: Copy and paste the below and your dates table will be created: DimDate = CALENDAR( DATE( 2018, 1, 1 )...

Birel

Issue with Excel Pivot table

I have a pivot table in Excel which is connected to 3 slicers [Dep Slicer, Rep slicer, Date slicer]. I created custom list to sort the pivot table in order of Rep1, Rep2, Rep3 ..... Rep40, this works ...

Faith

excel

pivot

slicers

Votes: 0

Answers: 0

Force user to select an option from slicer before displaying data in excel

I have a table which is is populated from summarized data. Because of this, when no options are selected from either slicer my data is invalid as it is averaging averages. Is there a way through VBA c...

Isaiah Kremer

excel

pivot

pivot-table

slicers

Votes: 0

Answers: 1

Latest Answer

If the user hasn't selected anything, the FilterCleared property should be true. You could set defaults when true using something like this. With MyWorkbook.SlicerCaches("MySlicer") If ....

John Williams

Automatic Slicer Selection VBA

I am trying to automate my dashboard as efficient as possible. For that i need my slicer to automatically select this month and the previous month. Currently it manually updates by a different macro f...

Gino Bianchi

excel

vba

dashboard

slicers

Votes: 0

Answers: 1

Latest Answer

Use Month() and DateAdd() to determine the current and previous months. Sub MTDSelectThisMonthAndPreviousMonth() Application.ScreenUpdating = False Application.Calculation = xlCalculationManua...

TinMan

Posts

Questions

Blogs

Jobs