The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I have a very simple question about the column chart visual, is it possible to add extra bars/columns from a different table/columns next to the main columns?
Solved! Go to Solution.
Hi, @kcsteele ;
You could add row by power query or use dax add rows. then create a measure. here I use dax to add rows.
1.create a new table.
New table = var _a=SUMMARIZE('Table',[Index],[Year],[percent])
var _b=SUMMARIZE('Table',"Index",MAX('Table'[Index])+1,"Year","16-20","percent",BLANK())
var _c=SUMMARIZE('Table',"Index",MAX('Table'[Index])+2,"Year","85-20","percent",BLANK())
return UNION(_a,_b,_c)
2.create a measure.
value =
SWITCH (
MAX ( [Year] ),
"16-20",
CALCULATE (
SUM ( 'Table'[percent] ),
FILTER ( 'Table', [Year] <= 20 && [Year] >= 16 )
),
"85-20", CALCULATE ( SUM ( 'Table'[percent] ), FILTER ( 'Table', [Year] <= 20 ) ),
MAX ( [percent] ))
The final output is shown below:
If not right ,please share more details.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @kcsteele ;
You could add row by power query or use dax add rows. then create a measure. here I use dax to add rows.
1.create a new table.
New table = var _a=SUMMARIZE('Table',[Index],[Year],[percent])
var _b=SUMMARIZE('Table',"Index",MAX('Table'[Index])+1,"Year","16-20","percent",BLANK())
var _c=SUMMARIZE('Table',"Index",MAX('Table'[Index])+2,"Year","85-20","percent",BLANK())
return UNION(_a,_b,_c)
2.create a measure.
value =
SWITCH (
MAX ( [Year] ),
"16-20",
CALCULATE (
SUM ( 'Table'[percent] ),
FILTER ( 'Table', [Year] <= 20 && [Year] >= 16 )
),
"85-20", CALCULATE ( SUM ( 'Table'[percent] ), FILTER ( 'Table', [Year] <= 20 ) ),
MAX ( [percent] ))
The final output is shown below:
If not right ,please share more details.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-yalanwu-msft,
Thanks so much for your help, I was able to achieve it by performing similar, however your solution may be a bit more elegant. I also created a separate "years" table with the added 85-20 and 16-20 rows, and then I created a new table for the values by taking the additional "16-20" and "85-20" columns from the mainData table, adding those columns along with the normal years 2016 - 2020 values columns. Then unpivoting all those columns, setting up the relationships and assigning the values to the well.
I guess I will try and add "16-20" and "85-20" as additional "years" to the "years" table and go from there? And then maybe use conditional formatting on the years. I was thinking if it's just possible out of the box without any of this finagling? Maybe with a different visual someone knows about.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
User | Count |
---|---|
138 | |
104 | |
75 | |
60 | |
60 |
User | Count |
---|---|
263 | |
128 | |
115 | |
95 | |
78 |