I have a SP list and it basically has list items that contain a bunch of information on Outages. Two records we are capturing is Type of Outage and Where at.
Outage Type - Choice Column
Where it is - Standard one line text column
I am trying to use a Bar Chart to show How Many Outages were Critical and Where they were so im thinking a side by side bar for each. I am also thinking of pulling this off a Gallery behind the bar chart with date filters.
The code I have in the Items of the Bar Chart is
AddColumns(
GroupBy(
AddColumns(nocc_outages,
"_outageMarket", MARKET
),
"Title", "_outageMarket", "_data"
),
"_outageMarketCount", CountRows(_data)
)
I currently have a Pie Chart and Bar Chart side by side but if I can just have a Bar Chart that groups by Market and then shows Major, Minor, Critical Bars and the count of each
The code for the Pie Chart is
AddColumns(
GroupBy(
AddColumns(nocc_outages,
"_outageType", OUTAGE_TYPE.Value
),
"Title", "_outageType", "_data"
),
"_outageCount", CountRows(_data)
)
Visually it all looks like this
But what im kind of wanting is this
Market at the bottom
and 3 bars showing Minor, Major and Critical and count the number of each record.
I hope all this makes sense to you and appreciate any help or direction in this. Im new to power apps but mostly self taught trial and error.
