Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to vizualize sales (from 2010 to 2020). I need 2 options :
- define the period : if i choose year, i will have 11 curves (2010, 2011,...), if i choose trimester, 42 (from 2010 T1 until 2020 T2), etc
- define the x axis : by trimester, by month, by week, by day
If i choose a "trimester" for period and "week" for x-axis, then i will have a x-axis from 1 to 13 (because you have 13 weeks in a trimester), so a simple date hierarchy cant solve all the problem.
I know how to use slicer to make a filter, but I dont have a solution to select the "period" or the "x axis" ?
Last information : all my data is in the same table.
Solved! Go to Solution.
@Anonymous , Did not get it completely.
But if you want to change axis you need bookmark -https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If you want to change measure, you can do like -https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
@Anonymous , Did not get it completely.
But if you want to change axis you need bookmark -https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
If you want to change measure, you can do like -https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |