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

[Anonymous]

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.

[amitchandak]

@Anonymous , Case one can done with bookmarks or with measure slicer.

For measure slicer, if both dates are in the same table, Join them with a common date table and for inactive join, you have to use userealtionship.  https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern

For the second one you need to use isfiltered/ hasonevalue - https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

if need to change axis , bookmark