user select on filter to show the bars

Question

Req: when user select below any filter on year&Quarter for example: user select 2020-H1

Filter : Year & Quarter   measure  sales

2019-H1, 2019-H2,  2020-H1, 2020-H2 -- 4 categiries

Barchart   X - axis (Year& Quarter), and Y-axis (Sales)  -- in bar chart to show the 3 categories

2019-H1, 2019-H2,  2020-H1

How to calculate this scenario? in Power BI desktop?

Answer 1

Hi, @There,

There are multiple steps which you need to follow: 

I will try to give an example source around your scenario-based I hope this will work for you:

Add a new visualization

Before you can customize your visualization, you have to build it.

1. In Power BI Desktop, open the Retail Analysis sample.

2. At the bottom, select the yellow plus icon to add a new page.

   

3. From the Visualizations pane, select the stacked column chart icon. This adds an empty template to your report canvas.

4. To set the X-axis values, from the Fields pane, select Time > FiscalMonth.

5. To set the Y-axis values, from the Fields pane, select Sales > Last Year Sales and Sales > This Year Sales > Value.

Customize the X-axis labels

The X-axis labels display below the columns in the chart. Right now, they're light grey, small, and difficult to read. Let's change that.

1. In the Visualizations pane, select Format (the paint roller icon  ) to reveal the customization options.

2. Expand the X-axis options.

3. Move the X-axis slider to On.

4. Some reasons you may want to set the X axis to Off, is if the visualization is self-explanatory without labels or if you have a crowded report page and need to make space to display more data.

5. Format the text color, size, and font:

   • Color: Select black

   • Text size: Enter 14

   • Font family: Select Arial Black

   • Inner padding: Enter 40%

Maybe you don't like the way the X-axis text is displayed on a diagonal. You have several options.

• Change the text size to something smaller than 14.
• Make the visualization larger.
• Display fewer columns and add a scrollbar by increasing Minimum category width.

Customize the Y-axis labels

The Y-axis labels are displayed to the left by default. Right now, they're light grey, small, and difficult to read. Let's change that.

1. Expand the Y-Axis options.

2. Move the Y-Axis slider to On.

   

   One reason you might want to turn off the Y-axis, is to save space for more data.

3. Format the text color, size, and font:

   • Color: Select black

   • Text size: Enter 10

   • Display units: Select Millions