Forum Discussion
Bar Chart
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?
Hi Anonymous ,
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!!!
2 Replies
Hi Anonymous ,
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!!!
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!