Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@Anonymous,
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
@Anonymous,
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
Fantastic, it working perfect, thank you so much
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...
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |