Problems while creating visuals

[shivar]

Hello All,

I have a table where the attributes are created date, pi number, deal vaue, confirmation date etc. I need to calculate total number of PI number, the pi number who are confirmed based on confirmation date, same applies to deal value. When i use a date slider the data is reflecting based on created date, i want to show few visuals based on created date and few visuals based on confirmation date.

Can anyone suggest what needs to be done in such case?

Thanks,

Shiva R

[shivar]

@amitchandak Thank you for the response.

[amitchandak · Accepted solution]

@shivar , while dates can be used as axis as well slicer. You can use common slicer and axis using date table and userelationship. Join date of date table with both dates and there will inactive joins. which you can activate using userelationship

refer

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

Assume inactive is confirmation date

calculate( SUM(Table[deal vaue]),USERELATIONSHIP ('Table'[confirmation Date], 'Date'[Date]))

You can confirmation value as

calculate( SUM(Table[deal vaue]), filter(Table, not(isblank(Table[confirmation Date]))))