card visualization help
2 Topics
How to get the count of Products where actuals+forecast values are greater than 0 in a card visual?
Hi All, In a card visual, I have used a measure which takes the distinct count of product no. Now in additional to that, I have to include a logic to get the distinct count of product no where Actuals + Forecast > 0. In the below example, the distinct count of product no where Actuals + Forecast > 0 is 4. This logic I need to achieve in a Card visual. Can anybody help me with the logic here? Product No Actuals Forecast 1 0 30 2 0 0 3 65 100 4 50 0 5 0 0 6 100 150 Thanks in advance!!Solved554Views0likes1Comment
display date in min/max card visualization
Hi all, I've been searching for a measure to display the date also for my min/max card visualization. Can power bi support this? E.g. I have daily sales since 2022 till now, and i have 2 cards showing the max/min sales in a given day. The card shows the max valu we reaced till today in sales, but i als need to add the date. Is there a way to do so?Solved3.3KViews0likes4Comments