Bar Chart

[alex_smith]

Hello,

I would like to make the chart below.

Basically every shop has six categories of revenue. I would like to compare in each category the whole market (ALL) versus some specific shops (Active). And also put a percentage above the graphs that depicts how many (%) shops are in each category.

The dataset has three columns:

Shopcode (distinct id)

Status (Active or Blank (Blank = Not Active))

Revenue (six bins/categories)

Any ideas on how can I make it?

[mangaus1111 · Accepted solution]

Hi @alex_smith ,

here it is the link to the pbi file. There are 2 charts one above the other.

https://1drv.ms/u/s!Aj45jbu0mDVJiGtumR6Wpv_4u24J?e=uKTFes 

Please hit the thumb and accept my answer as solution!!!

[alex_smith]

Hello @mangaus1111 ,

Many thanks for your answer!! Very clever!

I have one more question though. My data set has also some lines that have empty (blank) value on the 'Revenue' column, how will the DAX code change in order to FIlter OUT the Blank values?

Thanks in advance!