CODEWITHSUNDEEP
powerbipowerbi-desktop
Rahul Neekhra
Rahul Neekhra

Reputation: 810

How to show and hide the pie chart in Power BI

I have a requirement where I need to create the Pie Chart for all available EventTypes. For example I have following EventTypes available in my system.

  1. Buy
  2. Sell
  3. Hold
  4. Buy Back

Now if a company has only two types of EventTypes like "Buy" & "Sell" then Power Report should show only two charts and if another company has three EventTypes like "Buy", "Sell" & "Hold" then same Power BI report should show the three pie charts.

I have two approaches to achieve this.

Approach 1: Create pie chart for all possible EventTypes and show and hide the pie chart based on the EventTypes available for given company. So how I can show and hide the pie chart in this approach.

Approach 2: Thinking to create the pie chart on the fly (If possible in PowerBI) as I could have done many time in SSRS using list. If possible how can I do this?

Upvotes: 0

Views: 791

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40244

Approach 1 should work OK, I think.

Create a chart for each of the four EventType values and write measures or use filters such that the chart values return BLANK() for non-existing EventType values.

Upvotes: 1

Related Questions