Forum Discussion
Measure to bar chart
Dear Friend
i have three columns PO number,vdl,qg doc as shown below, fourth column "VDL/QG column" is dynamic Measure based on Slicer selection left side,
if select=vdl then VDL/QG column=VDL column or select=QG docs then VDL/QG column=QG doc column
i want to display VDL/QG column(measure) to Bar Chart to show count of Available,Pending,Not require etc
is there any way to do or other
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Unpivot the column VDL and QG Doc in Power Query Editor
= Table.Unpivot(#"Changed Type", {"VDL", "QG Doc"}, "Type", "Value")2. Create a bar chart visual
Best Regards
4 Replies
You can't use a measure as the axis, but you can create 3 measures:
- "Available" = CALCULATE( COUNT (Table[PO NUMBER]), KEEPFILTERS ( [VDL /OG Column] = "Available"))
- "Pending"
- "Not required"
And then you can show those on a bar chart.
My bad! It's a measure, so let's try:
- "Available" = CALCULATE( COUNT (Table[PO NUMBER]), FILTER(Table, [VDL /OG Column] = "Available"))
Hi Anonymous ,
I created a sample pbix file(see attachment), please check whether that is what you want.
1. Unpivot the column VDL and QG Doc in Power Query Editor
= Table.Unpivot(#"Changed Type", {"VDL", "QG Doc"}, "Type", "Value")2. Create a bar chart visual
Best Regards
