Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm new to Power BI and trying to understand the logic with the reports.
If I have a report in Power BI Desktop, and I use slicers for date (I created a date table with multiple values such as Date, Year, Quarter...IsCurrentYear, IsToday, etc.) can I display for example a bar graph showing monthly sales in comparision to previous periods...and also the daily sales?
I'm able to display the previous monthly sales by using the slicers and say current year...then if I insert another slicer for "istoday" and select "true" then it will bring my graph down to showing only today...when I want a chart showing today sales in one...and yearly sales in another.
Would I have to create reports and then a dashboard in the Power BI Online to do this?
Thanks!
Hi @unclejemima,
If I understand you correctly, it could be done. You may need to create a new measure for calculating today's sales, using some formula similar like below. Then add it to your bar graph.
Sales Today = IF ( HASONEVALUE ( 'Table1'[IsToday] ), IF ( VALUES ( 'Table1'[IsToday] ) = TRUE (), [Total Sales] ) )
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |