Reply
Frequent Visitor
Posts: 3
Registered: ‎12-16-2018
Accepted Solution

Power bi measure

[ Edited ]

Hello All, 

As you can see in image I am trying to filter M_Total Revenue based on dynamic slicer like for past 3 days, 7 days etc.

But when I add M_Total Profit into same table it is showing me all values of M_Total Profit while I want to see only row which is filtered by measure M_Total Revenue.

 

Appreciate your help.

 

Capture.JPG


Accepted Solutions
Moderator
Posts: 9,929
Registered: ‎03-10-2016

Re: Power bi measure

@Aries,

Do you want to show these rows where M_Total Revenue are not blank? If so, you can set the value of M_Total Revenue in visual level filter to be "Not blank". 

If the above method doesn't solve your issue, please share sample data of your table and expected result following the guide in this post:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Moderator
Posts: 9,929
Registered: ‎03-10-2016

Re: Power bi measure

@Aries,

Do you want to show these rows where M_Total Revenue are not blank? If so, you can set the value of M_Total Revenue in visual level filter to be "Not blank". 

If the above method doesn't solve your issue, please share sample data of your table and expected result following the guide in this post:https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor
Posts: 3
Registered: ‎12-16-2018

Re: Power bi measure

Fantastic, it working perfect, thank you so much

Frequent Visitor
Posts: 3
Registered: ‎12-16-2018

Re: Power bi measure

Hi 

 

Similar to previous query, for attached image, I want to show only those row which has value in right most column, here it is 01 Feb 2019 have value in two row only as mark with blue color line, once I see only these two row I want to see what was value of that symbol for respective past date in given columns. Thank you...

 

 

Capture.JPG