user select on filter to show the bars

0 votes
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?
Dec 10, 2020 in Power BI by anonymous
• 390 points
83 views

1 answer to this question.

0 votes

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.

    yellow plus sign

  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 Screenshot of 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.

    Screenshot of the On slider for the Y axis.

    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

answered Dec 10, 2020 by Gitika
• 65,950 points

Related Questions In Power BI

+1 vote
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

answered Jul 10, 2019 in Power BI by sindhu
4,575 views
+1 vote
1 answer

Need a DAX : To check the new escalations arrived, on the change of the escalation counter from zero to one or more

Yes exactly !  i need a measure for ...READ MORE

answered Sep 3, 2019 in Power BI by anonymous

edited Sep 3, 2019 476 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 17, 2019 in Power BI by anonymous
• 3,450 points
1,113 views
+1 vote
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

answered Sep 19, 2018 in Power BI by Nilesh
• 7,040 points
5,721 views
0 votes
1 answer

last 10 days data based on Date&time

Hi, @Vnk, Regarding your query, you have to ...READ MORE

answered Jun 4, 2020 in Power BI by Gitika
• 65,950 points
1,106 views
0 votes
1 answer

DAX Calculate function with and without FILTER

You could make [Measure12] return the same results as ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
746 views
0 votes
1 answer

Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

answered Sep 24, 2020 in Power BI by Gitika
• 65,950 points
321 views
0 votes
1 answer

Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

answered Sep 28, 2020 in Power BI by Gitika
• 65,950 points
264 views
0 votes
1 answer

How can You Change the Value Measure to Show Multiple Measures Dynamically?

You can dynamically change and switch functions ...READ MORE

answered Oct 20, 2020 in Power BI by Gitika
• 65,950 points
529 views