Using Dates in Power BI

[vat2do]

Hi,

I need a power BI solution further detail is given below:

I have below table name "MAIN":

Ticket No	Category	Created Date	Resolved Date	Breached Date

and another table name "DATE" with general dates for one year duration

Now I want to use 2 slicers 1st for category drop down list and 2nd for date slicer and want to see the count of tickets using card visual for a specific category and date range.

Lets say category is: High, Medium and Low

Can anyone help me to sort out this issue, Thanks in advance

[amitchandak · Accepted solution]

@vat2do , First one would be simple you can category slicer from this table and that will filter any measure (unless you remove category filter from measure)

For the second one, you need three measure, if need them on axis you can simply use Field paramater on columns and create that.

Second is have common date table, Three measures using userelationship for inactive joins and then use date on axis if needed , but have measure slicer again using field parameters

examples

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Field Parameters

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...