Pie chart is not in synch with slicer.

[Anonymous]

Hi Team,

I am working on a recquirement in powerbi. The requirement is something like this. I need to create a slicer which is having date column as value. Instead of List the "Date Inputs" must be shown in  "Between" view. We need to show last 1 year data by default in all of the visuals which ever placed on the report. Such as slicer, pie chart and matrix. I am able to show date from today to till last 1 year using visual level filter only in slicer. But if I will do that with other visuals then it will become static and it will not behave like a dynamic visual. My requirement is when I will load the powerbi report on my webpage then it has to show me the data which belongs to the data range which is set as a default value on the dateslicer and after that whenever i will do any changes on the slicer then it will prepare the graph accordingly.The pie chart has to populate the data which is set as default value in the date range filter.

[Anonymous]

you can sync a slicer and use it on any or all pages in a report.

In the current report, the District Monthly Sales page has a District Manager slicer, but what if we also wanted that slicer on the New Stores page? The New Stores page has a slicer, but it provides only Store Name information. With the Sync slicers pane, you can sync the District Manager slicer to these pages, so that slicer selections on any page affect visualizations on all three pages.

1. On the Power BI Desktop View menu, select Sync slicers.

   The Sync slicers pane appears between the Filters and Visualizations panes.

2. On the District Monthly Sales page of the report, select the District Manager slicer.

   Because you've already created a District Manager (DM) slicer on the Overview page, the Sync slicers pane appears as follows:

3. In the Sync column of the Sync slicers pane, select the Overview, District Monthly Sales, and New Stores pages.

   This selection causes the District Monthly Sales slicer to sync across these three pages.

4. In the Visible column of the Sync slicers pane, select the New Stores page.

   This selection causes the District Monthly Sales slicer to be visible in these three pages. The Sync slicers pane now appears as follows:

5. Observe the effects of syncing the slicer and making it visible on the other pages. On the District Monthly Sales page, notice that the District Manager slicer now shows the same selections as on the Overview page. On the New Stores page, the District Manager slicer is now visible and it selections affect the selections that are visible in the Store Name slicer.

[Anonymous]

Hi,

First of all i want to thank you for your quick response. Actually I don't have many pages in my report , there is only a single page in the report. The requirement is quite straight forward, I need to populate the data related to the date range selected in the slicer. I am attaching the snapshot of the date range slicer along with the visual for your clear understanding.

Startdate will be the date which fall on exactly 1 year before from current day. The default date of end date should be today's date.

Ideally the dates(startdate- date fall on an year before the currentdate enddate- current date) should be set as default values. The data belongs to this time range need to be populated on the visuals attached below. This functionality we have to implement in such a way so that the relevant data will be populated on the embedded report when the webpage(which contains the embedded report) will be loaded on screen.Kindly check below for the visual.

[v-evelk]

Hi,

Your description is quite entangled.

As I understood, you need to show a year period by default until someone picked other period.

So, why don't you use some class field in the code to detect the first call of Update method in your slicer visual.

In that case, you can try to set a year period for your filter, if it's first call of update.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com