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.
Hi !
this is mly first post I am a very beginner in PBI
simple question but can not find out the answer !
I do have a database with 1 line per project
On each project I do have 4 column with the spend of the project per Quarter
Q1 Q2 Q3 Q4
I would like to create a graph (Idealy a curve) Showing in X "Q1" "Q2" "Q3" "Q4" (just the column title) and in Y the sum of the column amount
I CAN T FIND OUT how to perform this super simple thing
can you help ?
many thx
Fred
Solved! Go to Solution.
Amit is absolutely right if you unpivot the datayou get to the solution you need
bleow steps:
Step 1: get to the Query editor by selecting 'edit query'
Step 2: select the columns Q1 to Q4 by holding the Shift key now right click and select 'unpivot columns'
Step 3: click 'close and apply' (your data should now look as below)
Step 4 build your visulaisation:
hope this helps 🙂
Gentleman : Thank you soooo much for the time you have been taking explaing it to me : Power Bi is a totally different approach and I must admit not easy
your time and advise are sincerely very much appreciated
BR
Frederic
Amit is absolutely right if you unpivot the datayou get to the solution you need
bleow steps:
Step 1: get to the Query editor by selecting 'edit query'
Step 2: select the columns Q1 to Q4 by holding the Shift key now right click and select 'unpivot columns'
Step 3: click 'close and apply' (your data should now look as below)
Step 4 build your visulaisation:
hope this helps 🙂
@Thrasymaque , one way is use all 4 as values in the visual(say Bar)
Second, unpivot the data and use it
https://radacad.com/pivot-and-unpivot-with-power-bi
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak sorry if I was not clear :
here is how is built the DB
And This Is the result I d like 🙂
is it more clear ?
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |