Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic slicer(parameter), cascading dynamic slicer values with Dynamic measure

senarios:

 

1, we'd like to have a page with two dates option anaysis, say [expected booked date] or [created date]

once we select [expected booked date], all axis values(sample x-axis use [expected booked date period year]) / data in this page will be corresponding data  lines to it. 

and also, the other slicer values, [fiscal year] will fetch values from table.[expected booked date fiscal year]

 

once we select [created date], all axis values(sample x-axis use [created date period year]) / data in this page will be corresponding data  lines to it. 

and also, the other slicer values, [fiscal year] will fetch values from table.[created date fiscal year].

 

how to  make this dynamic slicer/axis/cascading slicers working as desired?

 

2, we have two slicers, one is [bu segmentation], the other is [account priority/ bu segment values]

if [bu segmentation]='(all)', [accountpriority/ bu segment values] will shown values from table. [account priority]

if [bu segmentation] any one or ones , but not '(all)', [account priority/ bu segment values] will shown values from table. [bu segment values]

 

and you can see stacked column and lines chart showing, the stacked series is based on [account priority/ bu segment values]  values.

 

how about this one? how to make it?

 

 

both achieved in tableau already, now we need to recreate same dashboards with PBI Desktop.

 

 

1 Reply