Forum Discussion
Create 2 different multi-row cards to compare data
Anonymous , you can use the visual level filter. Or you need to use two slicers and one of them need come from an independent city table.
refer to this two date range example. Here in case of date range, you have city
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Super UserAnonymous , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
You can show 1-month data on one and another month data on the second month '
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Appreciate your Kudos.
amitchandak thanks for your response. I am working with Cities and I want to compare 2 cities data in same page.
Find below a screen shot of my visual but when select one city I haven't got the option to select a second one.
Thanks