Forum Discussion
Solved
Handling multiple dates with one date picker in semantic model
Good day all We are creating dashboard using Semantic model in power BI, we have two columns one when record is created on and another record modified on. Could you please advise what could ...
Unpivot Created On and Modified On into single EventDate + EventType columns in Power Query.
Date table connects to EventDate. One slicer filters both. Measures use IF(EventType = "Created", [count], [count]).
is theer any way we can handle both create date and modified date card and detailed tab seperately. As KPI card is seperate on summary page which will show data seperate for modified date and create date. As a next part when some click on that KPI card that will take them to the specific detailed tab.
So can we control the same with one date picker?
Regards
Mohit
grazitti_sapna
Super User
Super UserHi jainmohit0710,
Same measure would work for separate KPI cards, Just apply Type filter in visual filter on them accordingly.