Displaying single graph based off 2 sets of bookmarks

[TomBLG]

Hello everyone,

I have 9 graphs which are the combination of hourly, daily and weekly grouped data for 3 different insights (left-most buttons).

To clarify, I can't remove the Hourly/Daily/Weekly buttons and rely on the drilldown functionality as most of my fields are  performance formulas made in SQL which would give inaccurate reading if I were to say, average 168(number of hours in a week) hourly values for the weekly value.

Initially all I had were the top-right buttons and as such, I could just set bookmark actions on them with the appropriate combination of shown/hidden graphs. However now instead of 3 graphs, I need 9. If I understand bookmarks correctly, what I need can't be done this way as each bookmark is tied to a single snapshot with my shown/hidden graphs.

Only one graph should be visible at a time depending on what's selected in each of the 2 sets of buttons.

That said, I'm hoping there's some neat workaround with bookmarks I haven't tried or even some other solution that results in displaying a graph out of 9 based on 2 selections.

Unfortunately I'm unable to provide the pbix file, I understand this limits the assistance you can give me, but I hope it's not necessary in this case as I can work of an idea if need be.

Thank you so much for your time!

[MFelix · Accepted solution]

Hi @TomBLG ,

Using bookmarks you would need to create the 9 bookmarks has you are refering but also 12 buttons and then associate them with the different bookmarks.

In this case you would have the following buttons:

• Hourly
  • Site Mains water consuption
  • Process water consuption
  • Process waste Water
• Daily
  • Site Mains water consuption
  • Process water consuption
  • Process waste Water
• Weekly
  • Site Mains water consuption
  • Process water consuption
  • Process waste Water

Then you need to hide the buttons accordingly to your selection so if you select the hourly you would show the 3 buttons of the comsuption/process assocated with the Hourly, and similar to the other time periods, then you just need to select what is the default value you would present when you select the "main" button and you a bookmark that would be selected on the Hourly selection but also on the (Hourly)Site Mains water consuption for example.

[TomBLG]

I think this is it MFelix. It's been a long day, it completely went over my head the fact that I can hide buttons too and not just graphs. I'll give this a go tomorrow morning and either accept it as solution or reply back.

[MFelix]

If you need any assistance please tell me.

[TomBLG]

That did the trick indeed. Decided to go the other way around, have the graph-type buttons generate the periodicity buttons, just need to tidy things up, group some bookmarks and order my selections in a more logical manner. Might add a few green-colored action-less buttons to indicate which selection is active as well.

Thanks again for all the help.

[AlexisOlson]

You could keep the Hourly/Daily/Weekly as bookmarks (with the corresponding 3 visuals) but make the other a parameter that effectively switches between measures.

Basically, you define a new table with the three options to be chosen as a new parameter table (no relationships with other tables). You then use the column from that table to create a chiclet slicer where you can select which option to use via a switching measure similar to this:

VariableMeasure =
VAR MetricParameter = SELECTEDVALUE ( Param[Metric] )
RETURN
    SWITCH (
        MetricParameter,
        "Site Mains Water Consumption", [Site Main Water Consumption],
        "Process Water Consumption", [Process Water Consumption],
        "Process Waste Water", [Process Waste Water]
    )

[TomBLG]

Hi Alexis,

These names such as "Site Mains Water Consumption" aren't fields, but graph titles, so I don't think this will do the trick. That one in particular is for a graph using 7 different fields, some as stacked area, others are lines. For the daily/weekly version it uses stacked columns instead of stacked area and the x-axis is also different.

I do have something extremely similar to what you sent me but that's on an unpivoted dataset where I get my fields (Attributes) from a slicer. In this case I have a switch measure like that one to pick the slicer values from my 3 switch options which tie to 3 tables (Hourly, Daily and Weekly) with exactly the same field names.  For that it works great.

[AlexisOlson]

Yes, it's an oversimplification since I have no way of seeing what your fields actually are. It sounds like you'd need several switching measures to do this since you have several different measures showing at one time. I think what I'm suggesting would still work but hard to explain without knowing what measures you use under which selections.