- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Combine two visuals on one Clustered Column Chart
Is it possible to get two visuals onto one Clustered Column Chart?
So if I show Years on the X Axis I will see two columns for each year, with each column having its own set of Filters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Let me review when I get some time later this week as it looks promising.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @bdehning ,
Please tell me is this the result you expect to get?
Here is my sample data:
I created two measures and put them into the Clustered Column Chart to exist as values:
SUM = CALCULATE(
SUM('Table'[Value]),
FILTER(
'Table',
'Table'[ID] = SELECTEDVALUE('Table (2)'[ID_SUM])
)
)
AVERAGE = CALCULATE(
AVERAGE('Table'[Value]),
FILTER(
'Table',
'Table'[ID] = SELECTEDVALUE('Table (3)'[ID_AVERAGE])
)
)
Create a slicer based on table (2) and table (3) respectively. The results are as follows:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

This is rather problematic, you may have various valuses in those columns, which means 2 axis might be needed. You may calculate a table where you append those columns so it could be used the way you need, in a clustered bar chart.
However, to solve this easy way, I would suggest you use line and clustered barchart....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @bdehning
Please share supporting screenshots for sample Data and visual you have and the expected visual.
Please show the expected outcome based on the sample data you provided. Find how to provide sample data
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
How to get answered quickly
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Appreciate your KUDOS
Thanks
Pijush
Proud to be a Super User! | |

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-25-2024 09:38 AM | |||
06-17-2024 05:03 AM | |||
07-30-2024 12:17 PM | |||
Anonymous
| 04-01-2024 12:59 AM | ||
06-14-2023 05:31 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |