Forum Discussion
Card Visual not showing correct number
Hi, I currently have a card visual on power BI that is pulling from an excel sheet. The excel sheet shows percent of inventory each month for different regions and then the total. I need the card vi...
I got the card to show the correct number when I put a filter on the card to only show the total row and by changing the column in excel to percentages but I still cannot get it to show the correct number when I take the region filter off. I would like the region filter off of the card so when the drop down at the top is selected it will change the number displayed to show whichever region/the total is selected and that won't work if I have the filter on the card.