Forum Discussion

edan's avatar
edan
New Member
8 years ago
Solved

hide chart without data

Hi guys, i had some tableau background previously and was wondering if Power BI also has the ability to hide empty charts. With the following example data set Row_No     Col_1                  Col_...
  • Greg_Deckler's avatar
    8 years ago

    This seems like Tableau trolling to me. But, the answer is yes, it is possible although this scenario has been carefully constructed to attempt to show some kind of shortcoming in Power BI. Next time, perhaps use something less obvious than the old "Apples to Oranges" comparison. How are those "10 ways Power BI falls short" coming for you? Notice you took them off your web page.

     

    The answer to your question is two fold. One, you could use bookmarks to hide individual visuals.

     

    Second, you could use the following visuals instead of a pie chart for your 2nd pie chart.

    • table
    • matrix
    • multi-row card
    • line chart
    • area chart
    • stacked area chart
    • bubble chart
    • waterfall chart

    The first pie chart is simple, just Column1 and COUNT of Column1. The second chart you put in Column2 and the following measure:

     

    Measure = IF(ISFILTERED(ApplesOranges[Column1]),SUM(ApplesOranges[Column3]),BLANK())

    Easy. Give me something harder next time.

     

    I would be interested in how this is done in Tableau. The issue I see is that the second chart has data in it that is good, aggregated data in the context of ALL, so it is naturally going to display that data in the abscense of cross filtering so this is the way around that for Power BI but I don't know how you do that in Tableau.