Hi all! Please help a brother out. Is this possible in Power BI? I had to convert a Tableau Dashboard Report into a Power BI Report and here are the requirements:
Table:
Total Sales table
Date table
(1) Primary Date Range slicer - normal date range slicer
(2) Secondary Date Range slicer - contains 2 choices (month on month and year on year). This slicer must react to what choice user has set on (1) and display the result in a card.
(3) Primary Date Range Card - contains sum of total sales and filtered by the value of Primary Date Range slicer
(4) Secondary Date Range Card - contains sum of total sales and filtered by value of Secondary Date Range slicer
The goal is to capture the total sales and have it displayed on the cards. Purpose of this is to compare the sales based on the selected date.
