Forum Discussion
Using Dates in Power BI
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
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
Field Parameters
1 Reply
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
Field Parameters