Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Problem with applied filters when changing data parameters to get different data

Hi guys, 

 

i have a problem with applied filters when changing parameters. The think is, that we use one template for more customers. Data are in Azure Table Storage. That means when i change parameters to get the data for different customer and refresh model i still see applied filters (in slicers) from last customer. This causes, that sometimes reports are empty.

 

empty visuals.PNG

 

Solution is to change the organization (than the DYNATECH organization dissapear).

when changing organization.PNG

 

But still this couldnť happen. Am i right? Similar problem is below.

 

Second problem is that date slicers don´t show actual date. In some cases we have to filter visuals with only one date (we need actual date = youngest date in data table). But date slicer shows only prefiltered/preselected date. The same thing like upstairs  happening. In better case it shows only older data. How to deal with that?   

 

For showing the problem i will use same report (take a look to date slicer on the upper right side). So i have this report: 

when changing organization.PNG

 

When i change the data parameters for different organization and refresh it, this will happen (i have preselected the same date like on last image with different data): 

dnytech with old date.PNG

 

But in dates i have a more actual date: 

actual dates.PNG

  I would like to show the most actual date there - "čtvrtek 4. června 2020" (this means 4th of June 2020).

 

 

THANKS TO ALL OF YOU GUYS.

Tomas

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may take a look at this post and give feedback via Ideas to help improve Power BI.