Chapter 17 - Disconnected Tables / What-if Parameter

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Chapter 17 - Disconnected Tables / What-if Parameter

Postby DJBrennan » Sat Nov 07, 2020 5:39 pm

Thoroughly enjoying the book and I have learned a lot. Now in Chapter 17 and when trying to create a "what-if parameter" as described, I find that "New parameter" is greyed out. Can someone help?
Denis Brennan

RamanaV
Posts: 65
Joined: Thu Oct 19, 2017 12:57 pm

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Postby RamanaV » Sat Nov 07, 2020 10:32 pm

Click on Modeling tab in the menu.
You can then select New Parameter
Chapter17 Image 3.png
Chapter17 Image 3.png (12.48 KiB) Viewed 243 times
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Postby DJBrennan » Sat Nov 07, 2020 11:36 pm

That's exactly what I did but have just tried again and it works. Do I have to have a visual on the canvas before it will work? That seems to me to be the only difference. In any case, many thanks!

MattAllington
Posts: 1154
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Postby MattAllington » Sun Nov 08, 2020 6:05 am

I have seen this before. It is likely a minor bug somewhere.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

RamanaV
Posts: 65
Joined: Thu Oct 19, 2017 12:57 pm

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Postby RamanaV » Sun Nov 08, 2020 8:50 am

It is not necessary to have a visual on the canvas to use What-if New Parameter. As Matt said, it might be some minor bug somewhere. Save and close the workbook. Reopen it - it might work.
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Re: Chapter 17 - Disconnected Tables / What-if Parameter

Postby DJBrennan » Sun Nov 08, 2020 6:08 pm

Think it must be a bug. It's greyed out again.


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 0 guests