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 like to ask whether the follwing is possible to do and where I need to search for a solution:
I need to be able to present / list a number of items in a clean overview table, whereby consecutive years are displayed (18/19 or 19/20 etc - changeable by filter) and the difference between the years. The description like: 'Number of Companies' are all custom made titles as requested by the stakeholder, that is they need to be custamizable. It needs titles like 2021 2020 Differnce (%). The numbers are all individual measures to attain the results.
This can be quite easily be done in Tableau:
How do I archieve it in Power Bi? Where do I look for a solution?
Solved! Go to Solution.
@acg , If the rows are also split of measure. You need to use the calculation group for this year, last year, and change %
example
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Hi @acg
Most probably is doable but you need provide more details about your data, tables, relationships and sample explanation of each measure. Screenshots and sample data would be extremely helpful.
@acg , If the rows are also split of measure. You need to use the calculation group for this year, last year, and change %
example
This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |